DBA Data[Home] [Help]

APPS.CSTACPCS dependencies on CST_QUANTITY_LAYERS

Line 88: CST_QUANTITY_LAYERS CQL,

84: c_acct_close_date IN DATE)
85: IS
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

Line 634: cst_quantity_layers layer

630: (SELECT
631: nvl(sum(macd.new_cost),period_end_unit_cost)
632: FROM
633: mtl_cst_actual_cost_details macd,
634: cst_quantity_layers layer
635: WHERE
636: macd.inventory_item_id = mpsd.inventory_item_id AND
637: macd.organization_id = i_org_id AND
638: macd.layer_id = layer.layer_id AND