DBA Data[Home] [Help]

APPS.WIP_MTLPROC_PRIV dependencies on MTL_SYSTEM_ITEMS

Line 135: from mtl_material_transactions_temp mmtt, mtl_system_items_b msi

131: l_issueRec.rebuildItemID,
132: l_issueRec.rebuildJobName,
133: l_issueRec.rebuildActivityID,
134: l_issueRec.rebuildSerialNumber
135: from mtl_material_transactions_temp mmtt, mtl_system_items_b msi
136: where transaction_temp_id = p_txnTmpID
137: and mmtt.inventory_item_id = msi.inventory_item_id
138: and mmtt.organization_id = msi.organization_id
139: and nvl(flow_schedule, 'N') <> 'Y';

Line 573: FROM MTL_SYSTEM_ITEMS

569: SEGMENT18,
570: SEGMENT19,
571: SEGMENT20,
572: 1 -- Added for Bug 4703470
573: FROM MTL_SYSTEM_ITEMS
574: WHERE ORGANIZATION_ID = p_issueRec.orgID
575: AND INVENTORY_ITEM_ID = p_issueRec.itemID;
576:
577: if (l_logLevel <= wip_constants.full_logging) then