DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 2029: FROM mtl_secondary_inventories msi

2025:
2026: begin
2027: SELECT msi.secondary_inventory_name
2028: into l_sub_inventory
2029: FROM mtl_secondary_inventories msi
2030: where msi.organization_id = i.organization_id
2031: AND msi.secondary_inventory_name = p_product_txn_rec.sub_inventory
2032: AND NVL(msi.DISABLE_DATE,SYSDATE+1) > SYSDATE
2033: AND msi.QUANTITY_TRACKED = 1;

Line 3628: FROM mtl_secondary_inventories

3624: THEN
3625: BEGIN
3626: SELECT 'x'
3627: INTO l_dummy
3628: FROM mtl_secondary_inventories
3629: WHERE secondary_inventory_name =
3630: x_product_txn_rec.sub_inventory
3631: AND organization_id = l_ship_from_org_id;
3632: EXCEPTION