APPS.CSL_MTL_ONHAND_QTY_ACC_PKG dependencies on JTM_CSP_SEC_INV_ACC

Line 71: FROM jtm_csp_sec_inv_acc secacc

67: FROM mtl_onhand_quantities ohq
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: )

Line 127: FROM jtm_csp_sec_inv_acc secacc

123: FROM mtl_onhand_quantities ohq
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: )

Line 153: FROM jtm_csp_sec_inv_acc secacc

149: DELETE FROM CSL_MTL_ONHAND_QTY_MV
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: );

Line 171: FROM jtm_csp_sec_inv_acc secacc

167: FROM mtl_onhand_quantities
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: )