[Home] [Help]
18: IN_TRANSIT_RTL_AMT,BCKORDR_RTL_AMT,
19: QLTY_HOLD_RTL_AMT,SRC_SYS_IDNT, SRC_SYS_DT,
20: SRC_IDNT_FLAG, ACTION_FLAG, TRANS_DT
21: )
22: SELECT REC_ID, DDR_LOAD_SEQ.NEXTVAL,'Duplicate Record',
23: GLBL_ITEM_ID,GLBL_ITEM_ID_TYP, RTL_BSNS_UNIT_CD,
24: RTL_SKU_ITEM_NBR, INV_LOC_CD,UOM,
25: ON_HAND_QTY, RECVD_QTY,
26: IN_TRANSIT_QTY, BCK_ORDR_QTY,
113: SRC_IDNT_FLAG,
114: ACTION_FLAG,
115: TRANS_DT
116: )
117: SELECT REC_ID, DDR_LOAD_SEQ.NEXTVAL,'Duplicate Record',
118: RTL_BSNS_UNIT_CD,
119: PRMTN_TYP,
120: PRMTN_FROM_DT,
121: PRMTN_TO_DT,
215: ORDR_QTY,ORDR_AMT,SRC_SYS_IDNT,
216: SRC_SYS_DT, TRANS_DT, SRC_IDNT_FLAG,
217: ACTION_FLAG
218: )
219: SELECT REC_ID, DDR_LOAD_SEQ.NEXTVAL,'Duplicate Record',
220: RTL_BSNS_UNIT_CD,GLBL_ITEM_ID,
221: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP, UOM,
222: ORDR_QTY,ORDR_AMT,SRC_SYS_IDNT,
223: SRC_SYS_DT, TRANS_DT,'I','N'
292: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
293: UOM,SHIP_QTY, SHIP_AMT, SRC_SYS_IDNT,
294: SRC_SYS_DT, SRC_IDNT_FLAG, ACTION_FLAG, TRANS_DT
295: )
296: SELECT REC_ID, DDR_LOAD_SEQ.NEXTVAL,'Duplicate Record',
297: RTL_BSNS_UNIT_CD,GLBL_ITEM_ID,
298: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
299: UOM,SHIP_QTY, SHIP_AMT, SRC_SYS_IDNT,
300: SRC_SYS_DT,'I','N', TRANS_DT
375: SRC_SYS_DT, PERIOD_TYP_FLAG,
376: LOC_IDNT_CD, LOC_IDNT_FLAG,
377: ORG_LVL_CD,SRC_IDNT_FLAG, ACTION_FLAG,
378: TRANS_DT)
379: SELECT REC_ID, DDR_LOAD_SEQ.NEXTVAL,'Duplicate Record',
380: GLBL_ITEM_ID,RTL_SKU_ITEM_NBR,
381: GLBL_ITEM_ID_TYP, UOM, SLS_QTY,
382: SLS_AMOUNT,SLS_COST_AMOUNT,
383: RTRN_QTY, RTRN_AMOUNT,
456: LOC_IDNT_FLAG, ORG_LVL_CD,
457: SRC_IDNT_FLAG, ACTION_FLAG,
458: TRANS_DT
459: )
460: SELECT REC_ID,DDR_LOAD_SEQ.NEXTVAL,'Duplicate Record',
461: FRCST_SLS_UOM, FRCST_NBR,
462: FRCST_TYP, GLBL_ITEM_ID,
463: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
464: FRCST_SLS_QTY, FRCST_SLS_AMT,