APPS.CST_INVENTORY_PVT dependencies on CST_SUB_LIST_TEMP

Line 619: INTO cst_sub_list_temp(

615:
616: -- Populate subinventory list
617: l_stmt_num := 10;
618: INSERT
619: INTO cst_sub_list_temp(
620: subinventory_code
621: )
622: SELECT SUB.secondary_inventory_name
623: FROM mtl_secondary_inventories SUB

Line 632: FROM cst_sub_list_temp CSLT

628: AND SUB.secondary_inventory_name
629: BETWEEN NVL(p_subinventory_from, SUB.secondary_inventory_name)
630: AND NVL(p_subinventory_to, SUB.secondary_inventory_name)
631: AND NOT EXISTS ( SELECT 'Subinventory Already Exists'
632: FROM cst_sub_list_temp CSLT
633: where CSLT.subinventory_code = SUB.secondary_inventory_name
634: );
635:
636:

Line 741: cst_sub_list_temp CSLT

737: CILT.cost_type_id
738: FROM mtl_onhand_quantities MOQ,
739: cst_item_list_temp CILT,
740: cst_cg_list_temp CCLT,
741: cst_sub_list_temp CSLT
742: WHERE MOQ.organization_id = p_organization_id
743: AND CILT.inventory_item_id = MOQ.inventory_item_id
744: AND CCLT.cost_group_id = MOQ.cost_group_id
745: AND CSLT.subinventory_code = MOQ.subinventory_code

Line 796: cst_sub_list_temp CSLT

792: CILT.cost_type_id
793: FROM mtl_material_transactions MMT,
794: cst_item_list_temp CILT,
795: cst_cg_list_temp CCLT,
796: cst_sub_list_temp CSLT
797: WHERE MMT.organization_id = p_organization_id
798: AND CILT.inventory_item_id = MMT.inventory_item_id
799: AND CCLT.cost_group_id = MMT.cost_group_id
800: AND CSLT.subinventory_code = MMT.subinventory_code

Line 911: FROM cst_sub_list_temp CSLT

907: AND MMT.subinventory_code IS NULL
908: )
909: OR EXISTS (
910: SELECT 1
911: FROM cst_sub_list_temp CSLT
912: WHERE CSLT.subinventory_code = MMT.subinventory_code)
913: )
914: GROUP
915: BY MMT.cost_group_id,