APPS.MRP_AP_REL_PLAN_PUB dependencies on WSM_LOT_JOB_INTERFACE

Line 273: WSM_LOT_JOB_INTERFACE jsi

269: lv_job_schedule_type,
270: lv_start_date,
271: lv_wip_entity_id
272: FROM BOM_OPERATIONAL_ROUTINGS rtng,
273: WSM_LOT_JOB_INTERFACE jsi
274: WHERE jsi.group_id = G_WIP_GROUP_ID
275: AND jsi.load_type in (5,6) /* standard job */
276: AND rtng.assembly_item_id(+)= jsi.primary_item_id
277: AND rtng.organization_id(+)= jsi.organization_id

Line 301: update WSM_LOT_JOB_INTERFACE

297: If lv_details = 0 Then
298:
299: If lv_job_schedule_type(n) in (5,6) Then --bug#3459145
300:
301: update WSM_LOT_JOB_INTERFACE
302: set FIRST_UNIT_START_DATE = null
303: where GROUP_ID=G_WIP_GROUP_ID
304: and HEADER_ID=lv_header_id(n);
305:

Line 315: update WSM_LOT_JOB_INTERFACE

311:
312: /* when we are releasing the details, scheduling_method is 3 Bug 3401524*/
313:
314: IF var_lot_job_copy_rout = 1 THEN
315: update WSM_LOT_JOB_INTERFACE
316: set SCHEDULING_METHOD=3
317: where GROUP_ID=G_WIP_GROUP_ID
318: and HEADER_ID=lv_header_id(n);
319: END IF;

Line 1692: from WSM_LOT_JOB_INTERFACE a,

1688:
1689:
1690: Cursor C1 is
1691: Select a.header_id,min(bos.operation_seq_num) new_op_seq
1692: from WSM_LOT_JOB_INTERFACE a,
1693: WSM_LOT_JOB_DTL_INTERFACE b,
1694: bom_operation_Sequences bos,
1695: bom_operational_routings bor
1696: where a.group_id = b.group_id

Line 1721: from WSM_LOT_JOB_INTERFACE a,

1717: b.group_id,
1718: b.parent_header_id,
1719: b.INVENTORY_ITEM_ID_NEW,
1720: b.ROUTING_OP_SEQ_NUM
1721: from WSM_LOT_JOB_INTERFACE a,
1722: WSM_LOT_JOB_DTL_INTERFACE b
1723: where a.source_code = 'MSC'
1724: and a.group_id = G_WIP_GROUP_ID
1725: and a.group_id = b.group_id

Line 1741: from WSM_LOT_JOB_INTERFACE a,

1737: b.SRC_PHANTOM_ITEM_ID;
1738:
1739: Cursor C3 is
1740: select b.rowid
1741: from WSM_LOT_JOB_INTERFACE a,
1742: WSM_LOT_JOB_DTL_INTERFACE b
1743: where a.source_code = 'MSC'
1744: and a.group_id = G_WIP_GROUP_ID
1745: and a.group_id = b.group_id

Line 1837: 'INSERT INTO WSM_LOT_JOB_INTERFACE'

1833: and ALLOW_RELEASE_FLAG=1;
1834:
1835:
1836: lv_sqlstmt:=
1837: 'INSERT INTO WSM_LOT_JOB_INTERFACE'
1838: ||' ( LAST_UPDATE_DATE,'
1839: ||' MODE_FLAG,'
1840: ||' LAST_UPDATED_BY,'
1841: ||' CREATION_DATE,'

Line 2064: set wdi.parent_header_id = (select header_id from wsm_lot_job_interface whi

2060:
2061: EXECUTE IMMEDIATE lv_sqlstmt USING lv_instance_id,G_WIP_GROUP_ID;
2062:
2063: update WSM_LOT_JOB_DTL_INTERFACE wdi
2064: set wdi.parent_header_id = (select header_id from wsm_lot_job_interface whi
2065: where wdi.parent_header_id = whi.interface_id
2066: and wdi.GROUP_ID = whi.GROUP_ID
2067: and whi.GROUP_ID = G_WIP_GROUP_ID) ;
2068:

Line 2085: FROM WSM_LOT_JOB_INTERFACE

2081: -- Submit 'OSFM Load' Request --
2082: BEGIN
2083: SELECT 1
2084: INTO lv_dummy
2085: FROM WSM_LOT_JOB_INTERFACE
2086: WHERE GROUP_ID= G_WIP_GROUP_ID
2087: AND ROWNUM=1;
2088:
2089: --set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.