DBA Data[Home] [Help]

APPS.INVUPD2B dependencies on MTL_PENDING_ITEM_STATUS

Line 6372: insert into mtl_pending_item_status

6368: (( rec.msi_status_code <> rec.inventory_item_status_code )
6369: OR (NVL(rec.msi_lifecycle_id,1) <> NVL(rec.lifecycle_id,NVL(rec.msi_lifecycle_id,1)))
6370: OR (NVL(rec.msi_current_phase_id,1) <> NVL(rec.current_phase_id,NVL(rec.msi_current_phase_id,1)))))
6371: THEN
6372: insert into mtl_pending_item_status
6373: ( INVENTORY_ITEM_ID,
6374: ORGANIZATION_ID,
6375: STATUS_CODE,
6376: LIFECYCLE_ID,

Line 7086: -- Insert pending change record to the mtl_pending_item_status in case of revision phase change

7082: FOR update_rec IN c_lock_rev_record LOOP
7083:
7084: -- Bug 13935085: Item Revision Phase change done through Import from Excel does not show up
7085: -- in History Tab of Revision Phases.
7086: -- Insert pending change record to the mtl_pending_item_status in case of revision phase change
7087: IF (NVL(INV_EGO_REVISION_VALIDATE.Get_Process_Control(),'X')<> 'PLM_UI:Y' AND
7088: (NVL(update_rec.current_phase_id,1) <> NVL(rev_rec.current_phase_id,NVL(update_rec.current_phase_id,1))))
7089: THEN
7090: insert into mtl_pending_item_status

Line 7090: insert into mtl_pending_item_status

7086: -- Insert pending change record to the mtl_pending_item_status in case of revision phase change
7087: IF (NVL(INV_EGO_REVISION_VALIDATE.Get_Process_Control(),'X')<> 'PLM_UI:Y' AND
7088: (NVL(update_rec.current_phase_id,1) <> NVL(rev_rec.current_phase_id,NVL(update_rec.current_phase_id,1))))
7089: THEN
7090: insert into mtl_pending_item_status
7091: ( INVENTORY_ITEM_ID,
7092: ORGANIZATION_ID,
7093: REVISION_ID,
7094: LIFECYCLE_ID,