APPS.CST_INVENTORY_PVT dependencies on CST_SUB_LIST_TEMP

Line 679: INTO cst_sub_list_temp(

675:
676: -- Populate subinventory list
677: l_stmt_num := 10;
678: INSERT
679: INTO cst_sub_list_temp(
680: subinventory_code
681: )
682: SELECT SUB.secondary_inventory_name
683: FROM mtl_secondary_inventories SUB

Line 692: FROM cst_sub_list_temp CSLT

688: AND SUB.secondary_inventory_name
689: BETWEEN NVL(p_subinventory_from, SUB.secondary_inventory_name)
690: AND NVL(p_subinventory_to, SUB.secondary_inventory_name)
691: AND NOT EXISTS ( SELECT 'Subinventory Already Exists'
692: FROM cst_sub_list_temp CSLT
693: where CSLT.subinventory_code = SUB.secondary_inventory_name
694: );
695:
696:

Line 810: cst_sub_list_temp CSLT

806: CILT.cost_type_id
807: FROM mtl_onhand_quantities MOQ,
808: cst_item_list_temp CILT,
809: cst_cg_list_temp CCLT,
810: cst_sub_list_temp CSLT
811: WHERE MOQ.organization_id = p_organization_id
812: AND CILT.inventory_item_id = MOQ.inventory_item_id
813: AND CCLT.cost_group_id = MOQ.cost_group_id
814: AND CSLT.subinventory_code = MOQ.subinventory_code

Line 866: cst_sub_list_temp CSLT

862: CILT.cost_type_id
863: FROM mtl_material_transactions MMT,
864: cst_item_list_temp CILT,
865: cst_cg_list_temp CCLT,
866: cst_sub_list_temp CSLT
867: WHERE MMT.organization_id = p_organization_id
868: AND CILT.inventory_item_id = MMT.inventory_item_id
869: AND CCLT.cost_group_id = MMT.cost_group_id
870: AND CSLT.subinventory_code = MMT.subinventory_code

Line 986: FROM cst_sub_list_temp CSLT

982: AND MMT.subinventory_code IS NULL
983: )
984: OR EXISTS (
985: SELECT 1
986: FROM cst_sub_list_temp CSLT
987: WHERE CSLT.subinventory_code = MMT.subinventory_code)
988: )
989: GROUP
990: BY MMT.cost_group_id,