DBA Data[Home] [Help]

APPS.CSTACPCS dependencies on MTL_SECONDARY_INVENTORIES

Line 90: MTL_SECONDARY_INVENTORIES MSI

86: SELECT MCACD.TRANSACTION_ID
87: FROM MTL_CST_ACTUAL_COST_DETAILS MCACD,
88: CST_QUANTITY_LAYERS CQL,
89: MTL_MATERIAL_TRANSACTIONS MMT,
90: MTL_SECONDARY_INVENTORIES MSI
91: WHERE MCACD.INVENTORY_ITEM_ID = c_item_id
92: AND MCACD.ORGANIZATION_ID = c_org_id
93: AND MCACD.LAYER_ID = CQL.LAYER_ID
94: AND CQL.COST_GROUP_ID = c_cg_id

Line 339: MTL_SECONDARY_INVENTORIES SUB

335: i_prog_appl_id,
336: i_user_id
337: FROM
338: MTL_MATERIAL_TRANSACTIONS MMT,
339: MTL_SECONDARY_INVENTORIES SUB
340: WHERE
341: MMT.ORGANIZATION_ID = I_ORG_ID AND
342: MMT.ORGANIZATION_ID = nvl(MMT.OWNING_ORGANIZATION_ID, MMT.ORGANIZATION_ID) AND
343: NVL(MMT.OWNING_TP_TYPE,2) = 2 AND