APPS.CST_PERIODIC_AVERAGE_PROC_CP dependencies on CST_COST_GROUP_ASSIGNMENTS

Line 1182: , cst_cost_group_assignments ccga

1178: , NVL(mmt.transfer_organization_id,-1) transfer_organization_id
1179: , mmt.subinventory_code subinventory_code
1180: , nvl(mmt.transfer_price,0) transfer_price
1181: FROM mtl_material_transactions mmt
1182: , cst_cost_group_assignments ccga
1183: WHERE mmt.transaction_date BETWEEN c_period_start_date
1184: AND c_period_end_date
1185: AND ccga.organization_id = mmt.organization_id
1186: AND ccga.cost_group_id = c_cost_group_id

Line 1234: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

1230: where hoi2.organization_id = decode(mmt1.transaction_action_id,21,
1231: mmt1.transfer_organization_id, mmt1.organization_id)
1232: AND hoi2.org_information_context = 'Accounting Information'))
1233: AND NOT EXISTS ( SELECT 'X'
1234: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
1235: WHERE c1.organization_id = mmt1.organization_id
1236: AND c2.organization_id = mmt1.transfer_organization_id
1237: AND c1.cost_group_id = c2.cost_group_id)
1238: AND (

Line 1241: FROM cst_cost_group_assignments ccga1

1237: AND c1.cost_group_id = c2.cost_group_id)
1238: AND (
1239: (mmt1.transaction_action_id = 3 AND mmt1.transaction_source_type_id = 8
1240: AND EXISTS ( SELECT 'X'
1241: FROM cst_cost_group_assignments ccga1
1242: WHERE ccga1.cost_group_id = c_cost_group_id
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)

Line 1248: cst_cost_group_assignments ccga2

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

Line 1257: cst_cost_group_assignments ccga2

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
1261: AND ccga2.organization_id = mip.to_organization_id

Line 1284: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

1280: AND mmt2.organization_id = mp2.organization_id
1281: AND nvl(mp2.process_enabled_flag,'N') = 'N'
1282: AND mmt2.primary_quantity > 0
1283: AND NOT EXISTS ( SELECT 'X'
1284: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
1285: WHERE c1.organization_id = mmt2.organization_id
1286: AND c2.organization_id = mmt2.transfer_organization_id
1287: AND c1.cost_group_id = c2.cost_group_id)
1288: AND (

Line 1291: FROM cst_cost_group_assignments ccga2

1287: AND c1.cost_group_id = c2.cost_group_id)
1288: AND (
1289: (mmt2.transaction_action_id = 15
1290: AND EXISTS ( SELECT 'X'
1291: FROM cst_cost_group_assignments ccga2
1292: WHERE ccga2.organization_id = mmt2.organization_id
1293: AND ccga2.cost_group_id = c_cost_group_id))
1294: OR (mmt2.transaction_action_id = 3
1295: AND EXISTS ( SELECT 'X'

Line 1296: FROM cst_cost_group_assignments ccga3

1292: WHERE ccga2.organization_id = mmt2.organization_id
1293: AND ccga2.cost_group_id = c_cost_group_id))
1294: OR (mmt2.transaction_action_id = 3
1295: AND EXISTS ( SELECT 'X'
1296: FROM cst_cost_group_assignments ccga3
1297: ,mtl_parameters mp3
1298: WHERE mp3.organization_id = mmt2.transfer_organization_id
1299: AND nvl(mp3.process_enabled_flag,'N') = 'Y'
1300: AND ccga3.organization_id = mmt2.organization_id