[Home] [Help]
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
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
1294: AND ccga1.organization_id = mmt1.organization_id
1295: AND mmt1.primary_quantity > 0))
1296: OR (mmt1.transaction_action_id = 21
1297: AND EXISTS ( SELECT 'X'
1298: FROM mtl_interorg_parameters mip,
1299: cst_cost_group_assignments ccga2
1300: WHERE mip.from_organization_id = mmt1.organization_id
1301: AND mip.to_organization_id = mmt1.transfer_organization_id
1302: AND nvl(mmt1.fob_point,mip.fob_point) = 1
1303: AND ccga2.organization_id = mip.to_organization_id
1304: AND ccga2.cost_group_id = c_cost_group_id))
1305: OR (mmt1.transaction_action_id = 12
1306: AND EXISTS ( SELECT 'X'
1307: FROM mtl_interorg_parameters mip,
1308: cst_cost_group_assignments ccga2
1309: WHERE mip.from_organization_id = mmt1.transfer_organization_id
1310: AND mip.to_organization_id = mmt1.organization_id
1311: AND nvl(mmt1.fob_point,mip.fob_point) = 2