APPS.WSM_SERIAL_SUPPORT_PVT dependencies on WSM_SM_RESULTING_JOBS

Line 6779: wsm_sm_resulting_jobs WSRJ

6775: sysdate ,
6776: null
6777: from mtl_serial_numbers MSN ,
6778: wsm_sm_starting_jobs WSSJ ,
6779: wsm_sm_resulting_jobs WSRJ
6780: where MSN.current_organization_id = p_organization_id
6781: and MSN.inventory_item_id = WSRJ.primary_item_id
6782: and WSSJ.transaction_id = p_txn_id
6783: and WSRJ.transaction_id = p_txn_id

Line 6792: from wsm_sm_resulting_jobs

6788: IF l_serial_start_flag IS NOT NULL THEN
6789: update wip_discrete_jobs
6790: set serialization_start_op = 10
6791: where wip_entity_id in (select wip_entity_id
6792: from wsm_sm_resulting_jobs
6793: where transaction_id = p_txn_id);
6794:
6795: -- We set the first_serial_txn_id as a non-NULL value as some code depends on it.. in Move
6796: update wsm_lot_based_jobs

Line 6799: from wsm_sm_resulting_jobs

6795: -- We set the first_serial_txn_id as a non-NULL value as some code depends on it.. in Move
6796: update wsm_lot_based_jobs
6797: set first_serial_txn_id = -1
6798: where wip_entity_id in (select wip_entity_id
6799: from wsm_sm_resulting_jobs
6800: where transaction_id = p_txn_id);
6801:
6802: END IF;
6803:

Line 6879: wsm_sm_resulting_jobs WSRJ

6875: sysdate ,
6876: null
6877: from mtl_serial_numbers MSN ,
6878: wsm_sm_starting_jobs WSSJ ,
6879: wsm_sm_resulting_jobs WSRJ
6880: where MSN.current_organization_id = p_organization_id
6881: and MSN.inventory_item_id = WSSJ.primary_item_id
6882: and WSSJ.transaction_id = p_txn_id
6883: and WSRJ.transaction_id = p_txn_id

Line 7015: from wsm_sm_resulting_jobs

7011: IF l_serial_start_flag IS NOT NULL THEN
7012: update wip_discrete_jobs
7013: set serialization_start_op = 10
7014: where wip_entity_id in (select wip_entity_id
7015: from wsm_sm_resulting_jobs
7016: where transaction_id = p_txn_id);
7017:
7018: -- We set the first_serial_txn_id to NULL as some code depends on it.. in Move
7019: update wsm_lot_based_jobs

Line 7022: from wsm_sm_resulting_jobs

7018: -- We set the first_serial_txn_id to NULL as some code depends on it.. in Move
7019: update wsm_lot_based_jobs
7020: set first_serial_txn_id = -1
7021: where wip_entity_id in (select wip_entity_id
7022: from wsm_sm_resulting_jobs
7023: where transaction_id = p_txn_id);
7024: END IF;
7025: END IF;
7026: