|
SELECT a.BUSINESS_UNIT , a.EIP_CTL_ID , a.SEQ_NBR , a.TRANSACTION_CODE , a.LAST_DTTIME , a.BCT_DET_STATUS , a.STAGED_DATE , a.INV_LOT_ID , a.INV_ITEM_ID , a.SERIAL_ID , a.STORAGE_AREA , a.STOR_LEVEL_1 , a.STOR_LEVEL_2 , a.STOR_LEVEL_3 , a.STOR_LEVEL_4 , a.CONTAINER_ID , a.UNIT_OF_MEASURE , a.RECEIVER_ID , a.RECV_LN_NBR , a.TO_CONTAINER_ID , a.TO_STORAGE_AREA , a.TO_STOR_LEVEL_1 , a.TO_STOR_LEVEL_2 , a.TO_STOR_LEVEL_3 , a.TO_STOR_LEVEL_4 , a.QTY , a.COMPLETE_FLG , a.PRODUCTION_ID , a.PRDN_AREA_CODE , a.COMPL_OP_SEQ , a.UPDATE_OP_SEQ , a.PICK_BATCH_ID , a.PICKLIST_LINE_NO , a.COMPONENT_ID , a.COMPL_QTY , a.SCRAPPED_QTY , a.REASON_CD , a.PERCENT_COMP , a.DISTRIB_TYPE , a.TO_PRODUCTION_ID , a.PTWY_PLAN_ID , a.PTWYPLAN_LN_NBR , a.SHIP_CNTR_ID , a.DEMAND_SOURCE , a.SOURCE_BUS_UNIT , a.ORDER_NO , a.ORDER_INT_LINE_NO , a.SCHED_LINE_NBR , a.DEMAND_LINE_NO , a.QTY_CODE , a.OP_SEQUENCE , a.PEND_CONSUME_QTY , a.PEND_LOSS_QTY , a.REVISION , a.DEVICE_DTTIME , a.UOM_ORIG , a.ORIG_CONSUMED_QTY , a.ORIG_COMP_LOSS_QTY , a.YIELD_QTY , a.SHIPTO_SETID , a.SHIPTO_ID , a.VENDOR_ID , a.SHIPMENT_NO , a.CARRIER_ID , a.BILL_OF_LADING , a.BUSINESS_UNIT_PO , a.PO_ID , a.LINE_NBR , a.END_TRANS_FLG , a.ADJUST_TYPE , a.DOCUMENT_ID , a.EIP_TRANS_SRC_SEQ , a.PACKSLIP_NO , a.BUSINESS_UNIT_IN , a.INTERUNIT_ID , a.INTERUNIT_LINE , a.CONFIG_CODE , a.UNIT_MEASURE_COUNT , a.SHIP_ID , a.SHIP_LINE_NO , a.SHIP_DATE , a.SHIP_TIME , a.SHIP_TYPE_ID , a.FREIGHT_TERMS , a.PRO_NUMBER , a.SHIP_FLAG , a.BOM_CODE , a.RTG_CODE , a.SF_BOM_RTG_EFFDT , a.MG_OUTPUT_SEQ , a.MG_OUTPUT_ITEM , a.MG_OUTPUT_TYPE , a.MG_NEW_OUTPUT_QTY , a.MG_OUTPUT_RES_PCT , a.MG_OUTPUT_COMPL , a.BOM_QTY , a.MG_UNPLAN_OUTPUT , a.MG_TRANS_UOM , a.MG_OUTPUT_QTY_CODE , a.MG_RELATED_TRANS , a.CREW_RPT_FLAG , a.MACH_RPT_FLAG , a.CREWSIZE , a.MACH_RESOURCES , a.LAB_SETUP , a.LAB_RUN , a.LAB_FIXED_RUN , a.LAB_POSTPROD , a.MACH_SETUP , a.MACH_RUN , a.MACH_FIXED_RUN , a.MACH_POSTPROD , a.WORK_CENTER_CODE , a.SF_ENTRY_DATE , a.MG_ORIG_COMP_ID , a.MG_ORIG_QTY_PER , a.PARENT_ITEM_ID , a.SUB_ITM_ID , A.VENDOR_LOT_ID , A.TAG_NUMBER , A.MG_ISSUE_COMP_FLG , A.INV_CART_ID , A.COMPARTMENT , A.COUNT_ORDER , A.CART_COUNT_QTY , A.QTY_OPTION , A.SUFFICIENT_STOCK , A.IU_REC_ID_GRP_FLG , A.IU_REC_SEL_GRP_FLG , A.SPEEDTYPE_KEY , A.RTV_ID , A.RTV_LN_NBR , A.RTV_DISTRIB_NUM , A.SYNCH_FLAG , A.COUNTING_EVENT_ID , A.PORT_OF_UNLOADING , A.IST_RETURN_FLG_IUT , A.REPLACEMENT_FLG , A.PARENT_SHIP_CNTR , A.FREIGHT_AMT , A.FREIGHT_CURRNCY_CD , A.GROSS_WEIGHT , A.UNIT_MEASURE_WT , A.SF_KANBAN_ID , A.VNDR_LOC FROM PS_BCT_DTL a
|
BUSINESS_UNIT