APPS.CSTPALPC dependencies on CST_COST_GROUPS

Line 158: cst_cost_groups ccg,

154: (to_char(mtt.transaction_type_id)||'-'||to_char(mtt.transaction_action_id)||'-'||to_char(mtt.transaction_source_type_id)) "EVENT_TYPE", -- 4986702
155: 'INV' "TRANSACTION_TYPE_FLAG", -- 4986702
156: mmt.trx_source_line_id "TRX_SOURCE_LINE_ID"
157: FROM mtl_material_transactions mmt,
158: cst_cost_groups ccg,
159: cst_cost_group_assignments ccga,
160: cst_pac_periods cpp,
161: mtl_transaction_types mtt /* Removed the access to view to directly access the base tables Bug 4968702 */
162: WHERE

Line 239: cst_cost_groups ccg,

235: 'INV' "TRANSACTION_TYPE_FLAG", -- Bug 4968702
236: mmt.trx_source_line_id "TRX_SOURCE_LINE_ID"
237: FROM
238: mtl_material_transactions mmt,
239: cst_cost_groups ccg,
240: cst_cost_group_assignments ccga ,
241: cst_pac_periods cpp,
242: mtl_material_transactions mtt -- Directly Using the base tables. Bug 4968702
243: WHERE

Line 269: cst_cost_groups ccg,

265: 'WIP' "TRANSACTION_TYPE_FLAG", -- 4968702
266: NULL "TRX_SOURCE_LINE_ID"
267: FROM
268: wip_transactions wt,
269: cst_cost_groups ccg,
270: cst_cost_group_assignments ccga,
271: cst_pac_periods cpp
272: WHERE
273: wt.organization_id = ccga.organization_id AND

Line 301: cst_cost_groups ccg,

297: 'RCV' "TRANSACTION_TYPE_FLAG", -- 4968702
298: NULL "TRX_SOURCE_LINE_ID"
299: FROM
300: rcv_transactions rt,
301: cst_cost_groups ccg,
302: cst_cost_group_assignments ccga,
303: cst_pac_periods cpp,
304: po_lookup_codes plc
305: WHERE

Line 356: cst_cost_groups ccg,

352: NULL "TRX_SOURCE_LINE_ID"
353: FROM
354: rcv_accounting_events rae,
355: rcv_transactions rt,
356: cst_cost_groups ccg,
357: cst_cost_group_assignments ccga,
358: cst_pac_periods cpp
359:
360: WHERE

Line 400: CST_COST_GROUPS CCG,

396: 'ADJ' "TRANSACTION_TYPE_FLAG",
397: NULL "TRX_SOURCE_LINE_ID"
398: FROM RCV_ACCOUNTING_EVENTS RAE,
399: RCV_TRANSACTIONS RT,
400: CST_COST_GROUPS CCG,
401: CST_COST_GROUP_ASSIGNMENTS CCGA,
402: CST_PAC_PERIODS CPP
403: WHERE RAE.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
404: AND CCGA.COST_GROUP_ID = CCG.COST_GROUP_ID

Line 432: CST_COST_GROUPS CCG,

428: 'LC ADJ' "TRANSACTION_TYPE_FLAG",
429: NULL "TRX_SOURCE_LINE_ID"
430: FROM RCV_ACCOUNTING_EVENTS RAE,
431: RCV_TRANSACTIONS RT,
432: CST_COST_GROUPS CCG,
433: CST_COST_GROUP_ASSIGNMENTS CCGA,
434: CST_PAC_PERIODS CPP
435: WHERE RAE.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
436: AND CCGA.COST_GROUP_ID = CCG.COST_GROUP_ID

Line 621: cst_cost_groups ccg,

617: caet.event_type "EVENT_TYPE",
618: caet.transaction_type_flag "TRANSACTION_TYPE_FLAG"
619: FROM
620: rcv_transactions rt,
621: cst_cost_groups ccg,
622: cst_cost_group_assignments ccga,
623: cst_pac_periods cpp,
624: cst_accounting_event_types_v caet
625: WHERE