DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on CST_QUANTITY_LAYERS

Line 3712: cst_quantity_layers CQL,

3708: cost_type_id
3709: FROM cst_inv_qty_temp
3710: WHERE qty_source NOT IN (1,2,9,10)
3711: ) CIQT,
3712: cst_quantity_layers CQL,
3713: cst_item_costs CIC,
3714: mtl_parameters MP
3715: WHERE CIC.organization_id = CIQT.organization_id
3716: AND CIC.inventory_item_id = CIQT.inventory_item_id

Line 4270: cst_quantity_layers CQL,

4266: AND CICT.cost_source = 2
4267: )
4268: AND CIQT.organization_id = p_organization_id
4269: ) CIQT,
4270: cst_quantity_layers CQL,
4271: (
4272: SELECT /*+ ORDERED use_hash(MMT,MIP) swap_join_inputs(MIP) */
4273: MIN(MMT.transaction_id) transaction_id,
4274: MMT.transaction_date,

Line 4599: FROM cst_quantity_layers CQL,

4595: NVL(CQL.material_overhead_cost,0),
4596: NVL(CQL.resource_cost,0),
4597: NVL(CQL.outside_processing_cost,0),
4598: NVL(CQL.overhead_cost,0)
4599: FROM cst_quantity_layers CQL,
4600: (
4601: SELECT DISTINCT
4602: CIQT.organization_id,
4603: CIQT.inventory_item_id,