DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 1984: FROM mtl_secondary_inventories msi

1980:
1981: begin
1982: SELECT msi.secondary_inventory_name
1983: into l_sub_inventory
1984: FROM mtl_secondary_inventories msi
1985: where msi.organization_id = i.organization_id
1986: AND msi.secondary_inventory_name = p_product_txn_rec.sub_inventory
1987: AND NVL(msi.DISABLE_DATE,SYSDATE+1) > SYSDATE
1988: AND msi.QUANTITY_TRACKED = 1;

Line 3532: FROM mtl_secondary_inventories

3528: THEN
3529: BEGIN
3530: SELECT 'x'
3531: INTO l_dummy
3532: FROM mtl_secondary_inventories
3533: WHERE secondary_inventory_name =
3534: x_product_txn_rec.sub_inventory
3535: AND organization_id = l_ship_from_org_id;
3536: EXCEPTION