DBA Data[Home] [Help]

APPS.CST_LCMADJUSTMENTS_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 857: mtl_secondary_inventories mse

853: FROM mtl_material_transactions mmt,
854: cst_lc_rcv_txn_gt rt,
855: cst_cost_group_accounts ccga,
856: cst_lc_adj_acctg_info_gt acc,
857: mtl_secondary_inventories mse
858: WHERE mmt.transaction_source_type_id = 1
859: AND mmt.organization_id = p_organization_id
860: AND mmt.rcv_transaction_id = rt.rcv_transaction_id
861: AND mse.organization_id = p_organization_id

Line 1544: mtl_secondary_inventories mse,

1540: 2,
1541: msi.primary_uom_code
1542: FROM cst_lc_adj_acctg_info_gt acc,
1543: cst_lc_rcv_txn_gt rt,
1544: mtl_secondary_inventories mse,
1545: mtl_material_transactions mmt,
1546: mtl_system_items_b msi
1547: WHERE (rt.transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')
1548: or (rt.transaction_type = 'CORRECT'

Line 1695: mtl_secondary_inventories mse

1691: FROM mtl_material_transactions mmt,
1692: mtl_cst_layer_act_cost_details mclacd,
1693: cst_lc_adj_acctg_info_gt acc,
1694: cst_lc_rcv_txn_gt rt,
1695: mtl_secondary_inventories mse
1696: WHERE (rt.transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')
1697: or (rt.transaction_type = 'CORRECT'
1698: and rt.parent_transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')))
1699: and rt.lcm_transaction_id = acc.lcm_transaction_id