DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on CST_QUANTITY_LAYERS

Line 3891: cst_quantity_layers CQL,

3887: cost_type_id
3888: FROM cst_inv_qty_temp
3889: WHERE qty_source NOT IN (1,2,9,10)
3890: ) CIQT,
3891: cst_quantity_layers CQL,
3892: cst_item_costs CIC,
3893: mtl_parameters MP
3894: WHERE CIC.organization_id = CIQT.organization_id
3895: AND CIC.inventory_item_id = CIQT.inventory_item_id

Line 4406: cst_quantity_layers CQL,

4402: SUM(
4403: DECODE(MCACD.cost_element_id,5,NVL(MCACD.prior_cost,0),0)
4404: )
4405: from mtl_cst_actual_cost_details MCACD,
4406: cst_quantity_layers CQL,
4407: ( select organization_id,
4408: inventory_item_id,
4409: cost_group_id,
4410: transaction_id,

Line 4435: from cst_quantity_layers CQL,

4431: RAW_DATA.transaction_id,
4432: RAW_DATA.transaction_date,
4433: RAW_DATA.transaction_costed_date,
4434: RAW_DATA.creation_date
4435: from cst_quantity_layers CQL,
4436: ( SELECT /*+ no_merge */
4437: DISTINCT
4438: CIQT1.organization_id,
4439: CIQT1.inventory_item_id,

Line 4623: FROM cst_quantity_layers CQL,

4619: NVL(CQL.material_overhead_cost,0),
4620: NVL(CQL.resource_cost,0),
4621: NVL(CQL.outside_processing_cost,0),
4622: NVL(CQL.overhead_cost,0)
4623: FROM cst_quantity_layers CQL,
4624: (
4625: SELECT DISTINCT
4626: CIQT.organization_id,
4627: CIQT.inventory_item_id,