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 1283: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2, cst_cost_groups ccg1, cst_cost_groups ccg2

1279: AND nvl(mmt1.owning_tp_type,2) = 2
1280: AND mmt1.organization_id = mp1.organization_id
1281: AND nvl(mp1.process_enabled_flag,'N') = 'N'
1282: AND NOT EXISTS ( SELECT 'X'
1283: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2, cst_cost_groups ccg1, cst_cost_groups ccg2
1284: WHERE c1.organization_id = mmt1.organization_id
1285: AND c2.organization_id = mmt1.transfer_organization_id
1286: AND c1.cost_group_id = ccg1.cost_group_id
1287: AND c2.cost_group_id = ccg2.cost_group_id

Line 1292: FROM cst_cost_group_assignments ccga1

1288: AND ccg1.legal_entity = ccg2.legal_entity)
1289: AND (
1290: (mmt1.transaction_action_id = 3
1291: AND EXISTS ( SELECT 'X'
1292: FROM cst_cost_group_assignments ccga1
1293: WHERE ccga1.cost_group_id = c_cost_group_id
1294: AND ccga1.organization_id = mmt1.organization_id
1295: AND mmt1.primary_quantity > 0))
1296: OR (mmt1.transaction_action_id = 21

Line 1299: cst_cost_group_assignments ccga2

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

Line 1308: cst_cost_group_assignments ccga2

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

Line 1335: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

1331: AND mmt2.organization_id = mp2.organization_id
1332: AND nvl(mp2.process_enabled_flag,'N') = 'N'
1333: AND mmt2.primary_quantity > 0
1334: AND NOT EXISTS ( SELECT 'X'
1335: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
1336: WHERE c1.organization_id = mmt2.organization_id
1337: AND c2.organization_id = mmt2.transfer_organization_id
1338: AND c1.cost_group_id = c2.cost_group_id)
1339: AND (

Line 1342: FROM cst_cost_group_assignments ccga2

1338: AND c1.cost_group_id = c2.cost_group_id)
1339: AND (
1340: (mmt2.transaction_action_id = 15
1341: AND EXISTS ( SELECT 'X'
1342: FROM cst_cost_group_assignments ccga2
1343: WHERE ccga2.organization_id = mmt2.organization_id
1344: AND ccga2.cost_group_id = c_cost_group_id))
1345: OR (mmt2.transaction_action_id = 3
1346: AND EXISTS ( SELECT 'X'

Line 1347: FROM cst_cost_group_assignments ccga3

1343: WHERE ccga2.organization_id = mmt2.organization_id
1344: AND ccga2.cost_group_id = c_cost_group_id))
1345: OR (mmt2.transaction_action_id = 3
1346: AND EXISTS ( SELECT 'X'
1347: FROM cst_cost_group_assignments ccga3
1348: ,mtl_parameters mp3
1349: WHERE mp3.organization_id = mmt2.transfer_organization_id
1350: AND nvl(mp3.process_enabled_flag,'N') = 'Y'
1351: AND ccga3.organization_id = mmt2.organization_id