DBA Data[Home] [Help]

APPS.MRP_AP_REL_PLAN_PUB dependencies on WSM_LOT_SM_IFC_HEADER_S

Line 389: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

385: FND_GLOBAL.USER_ID,
386: FND_GLOBAL.USER_ID,
387: SYSDATE,
388: FND_GLOBAL.USER_ID,
389: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
390: G_WIP_GROUP_ID,
391: lv_header_id(n),
392: lv_nwk_job_op_seq_num(j),
393: lv_nwk_op_seq_num(j),

Line 681: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

677: FND_GLOBAL.USER_ID,
678: FND_GLOBAL.USER_ID,
679: SYSDATE,
680: FND_GLOBAL.USER_ID,
681: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
682: G_WIP_GROUP_ID,
683: lv_header_id(n),
684: lv_unschd_op_seq_num(l),
685: lv_unschd_res_seq_num(l),

Line 773: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

769: FND_GLOBAL.USER_ID,
770: FND_GLOBAL.USER_ID,
771: SYSDATE,
772: FND_GLOBAL.USER_ID,
773: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
774: G_WIP_GROUP_ID,
775: lv_header_id(n),
776: null,
777: lv_nwk_op_seq_num(k),

Line 820: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

816: FND_GLOBAL.USER_ID,
817: FND_GLOBAL.USER_ID,
818: SYSDATE,
819: FND_GLOBAL.USER_ID,
820: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
821: G_WIP_GROUP_ID,
822: lv_header_id(n),
823: null,
824: lv_nwk_op_seq_num(k),

Line 1074: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

1070: FND_GLOBAL.USER_ID,
1071: FND_GLOBAL.USER_ID,
1072: SYSDATE,
1073: FND_GLOBAL.USER_ID,
1074: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1075: G_WIP_GROUP_ID,
1076: lv_header_id(n),
1077: lv_unschd_job_op_seq_num(l),
1078: lv_unschd_rtng_op_seq_num(l),

Line 1197: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

1193: FND_GLOBAL.USER_ID,
1194: FND_GLOBAL.USER_ID,
1195: SYSDATE,
1196: FND_GLOBAL.USER_ID,
1197: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1198: G_WIP_GROUP_ID,
1199: lv_header_id(n),
1200: null,
1201: lv_unschd_op_seq_num(l),

Line 1279: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

1275: FND_GLOBAL.USER_ID,
1276: FND_GLOBAL.USER_ID,
1277: SYSDATE,
1278: FND_GLOBAL.USER_ID,
1279: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1280: G_WIP_GROUP_ID,
1281: lv_header_id(n),
1282: lv_nwk_job_op_seq_num(k),
1283: lv_nwk_op_seq_num(k),

Line 1326: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

1322: FND_GLOBAL.USER_ID,
1323: FND_GLOBAL.USER_ID,
1324: SYSDATE,
1325: FND_GLOBAL.USER_ID,
1326: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1327: G_WIP_GROUP_ID,
1328: lv_header_id(n),
1329: lv_nwk_job_op_seq_num(k),
1330: lv_nwk_op_seq_num(k),

Line 1421: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

1417: FND_GLOBAL.USER_ID,
1418: FND_GLOBAL.USER_ID,
1419: SYSDATE,
1420: FND_GLOBAL.USER_ID,
1421: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1422: G_WIP_GROUP_ID,
1423: lv_header_id(n),
1424: lv_nwk_job_op_seq_num(k),
1425: lv_nwk_op_seq_num(k),

Line 1502: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

1498: FND_GLOBAL.USER_ID,
1499: FND_GLOBAL.USER_ID,
1500: SYSDATE,
1501: FND_GLOBAL.USER_ID,
1502: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1503: G_WIP_GROUP_ID,
1504: lv_header_id(n),
1505: null,
1506: lv_nwk_op_seq_num(k),

Line 1548: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

1544: FND_GLOBAL.USER_ID,
1545: FND_GLOBAL.USER_ID,
1546: SYSDATE,
1547: FND_GLOBAL.USER_ID,
1548: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1549: G_WIP_GROUP_ID,
1550: lv_header_id(n),
1551: null,
1552: lv_nwk_op_seq_num(k),

Line 1643: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

1639: FND_GLOBAL.USER_ID,
1640: FND_GLOBAL.USER_ID,
1641: SYSDATE,
1642: FND_GLOBAL.USER_ID,
1643: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1644: G_WIP_GROUP_ID,
1645: lv_header_id(n),
1646: null,
1647: lv_nwk_op_seq_num(k),

Line 1932: ||' WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,'

1928: ||' 2,TRUNC(ROUTING_REFERENCE_ID/2),' /* decode routing_sequence_id */
1929: ||' ROUTING_REFERENCE_ID),' /* for OPM only */
1930: ||' BILL_RTG_EXPLOSION_FLAG,'
1931: ||' decode(:var_lot_job_copy_rout,2,decode(LOAD_TYPE,6,2,3),1),'
1932: ||' WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,'
1933: ||' HEADER_ID, '
1934: -- dsr added 2 new columns
1935: ||' Schedule_priority,'
1936: ||' Requested_completion_date '

Line 2002: ||' WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,'

1998: ||' USAGE_RATE_OR_AMOUNT,'
1999: ||' SCHEDULED_FLAG ,'
2000: ||' PARENT_RESOURCE_SEQ_NUM) ' -- dsr
2001: || ' SELECT'
2002: ||' WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,'
2003: || G_WIP_GROUP_ID || ','
2004: ||' PARENT_HEADER_ID,'
2005: ||' LOAD_TYPE,'
2006: ||' SUBSTITUTION_TYPE,'