DBA Data[Home] [Help]

APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on MTL_INTERORG_PARAMETERS

Line 1821: FROM mtl_interorg_parameters mip

1817: AND ccga2.cost_group_id = c_cost_group_id)
1818: )
1819: OR (mmt.transaction_action_id = 12
1820: AND EXISTS (SELECT 'X'
1821: FROM mtl_interorg_parameters mip
1822: WHERE mip.from_organization_id = mmt.transfer_organization_id
1823: AND mip.to_organization_id = mmt.organization_id
1824: AND (
1825: (NVL(mmt.fob_point,mip.fob_point) = 1

Line 2010: FROM mtl_interorg_parameters mip

2006: AND ccga2.cost_group_id = c_cost_group_id)
2007: )
2008: OR (mmt.transaction_action_id = 12
2009: AND EXISTS (SELECT 'X'
2010: FROM mtl_interorg_parameters mip
2011: WHERE mip.from_organization_id = mmt.transfer_organization_id
2012: AND mip.to_organization_id = mmt.organization_id
2013: AND (
2014: (NVL(mmt.fob_point,mip.fob_point) = 1

Line 2823: mtl_interorg_parameters mip,

2819: SELECT /*+ ORDERED INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N5)*/
2820: mmt.inventory_item_id inventory_item_id
2821: FROM cst_cost_groups ccg,
2822: cst_cost_group_assignments ccga,
2823: mtl_interorg_parameters mip,
2824: mtl_material_transactions mmt
2825: WHERE mmt.transaction_date between p_period_start_date AND p_period_end_date
2826: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2827: AND nvl(mmt.owning_tp_type,2) = 2