APPS.CSL_MTL_ONHAND_QTY_ACC_PKG dependencies on CSP_SEC_INVENTORIES

Line 72: , csp_sec_inventories secinv

68: WHERE (ohq.subinventory_code, ohq.organization_id) IN
69: ( SELECT secinv.secondary_inventory_name
70: , secinv.organization_id
71: FROM jtm_csp_sec_inv_acc secacc
72: , csp_sec_inventories secinv
73: WHERE secacc.secondary_inventory_id = secinv.secondary_inventory_id
74: AND condition_type = 'G'
75: )
76: GROUP BY ohq.subinventory_code,

Line 128: , csp_sec_inventories csi

124: WHERE (subinventory_code, organization_id) IN
125: ( SELECT csi.secondary_inventory_name
126: , csi.organization_id
127: FROM jtm_csp_sec_inv_acc secacc
128: , csp_sec_inventories csi
129: WHERE csi.SECONDARY_INVENTORY_ID = secacc.SECONDARY_INVENTORY_ID
130: AND csi.CONDITION_TYPE = 'G'
131: )
132: AND NOT EXISTS ( SELECT NULL

Line 154: , csp_sec_inventories csi

150: WHERE (subinventory_code, organization_id) not in (
151: SELECT csi.secondary_inventory_name
152: , csi.organization_id
153: FROM jtm_csp_sec_inv_acc secacc
154: , csp_sec_inventories csi
155: WHERE secacc.secondary_inventory_id = csi.secondary_inventory_id
156: AND csi.condition_type = 'G'
157: );
158:

Line 172: , csp_sec_inventories csi

168: WHERE (subinventory_code, organization_id) IN (
169: SELECT csi.secondary_inventory_name
170: , csi.organization_id
171: FROM jtm_csp_sec_inv_acc secacc
172: , csp_sec_inventories csi
173: WHERE csi.SECONDARY_INVENTORY_ID = secacc.SECONDARY_INVENTORY_ID
174: AND csi.CONDITION_TYPE = 'G'
175: )
176: );