DBA Data[Home] [Help]

APPS.CST_PERIODIC_AVERAGE_PROC_CP dependencies on MTL_INTERORG_PARAMETERS

Line 1247: FROM mtl_interorg_parameters mip,

1243: AND ccga1.organization_id = mmt1.organization_id
1244: AND mmt1.primary_quantity > 0))
1245: OR (mmt1.transaction_action_id = 21 AND mmt1.transaction_source_type_id IN (7,8)
1246: AND EXISTS ( SELECT 'X'
1247: FROM mtl_interorg_parameters mip,
1248: cst_cost_group_assignments ccga2
1249: WHERE mip.from_organization_id = mmt1.organization_id
1250: AND mip.to_organization_id = mmt1.transfer_organization_id
1251: AND nvl(mmt1.fob_point,mip.fob_point) = 1

Line 1256: FROM mtl_interorg_parameters mip,

1252: AND ccga2.organization_id = mip.to_organization_id
1253: AND ccga2.cost_group_id = c_cost_group_id))
1254: OR (mmt1.transaction_action_id = 12 AND mmt1.transaction_source_type_id IN (7,8)
1255: AND EXISTS ( SELECT 'X'
1256: FROM mtl_interorg_parameters mip,
1257: cst_cost_group_assignments ccga2
1258: WHERE mip.from_organization_id = mmt1.transfer_organization_id
1259: AND mip.to_organization_id = mmt1.organization_id
1260: AND nvl(mmt1.fob_point,mip.fob_point) = 2