DBA Data[Home] [Help]

APPS.CSTPALPC dependencies on CST_COST_GROUP_ASSIGNMENTS

Line 159: cst_cost_group_assignments ccga,

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
163: /* Periodic Cost Updates have the item master organization_id as

Line 240: cst_cost_group_assignments ccga ,

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
244: mmt.organization_id = ccga.organization_id AND

Line 270: cst_cost_group_assignments ccga,

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
274: ccga.cost_group_id = ccg.cost_group_id AND

Line 302: cst_cost_group_assignments ccga,

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
306: rt.organization_id = ccga.organization_id AND

Line 357: cst_cost_group_assignments ccga,

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
361: rae.organization_id = ccga.organization_id AND

Line 401: CST_COST_GROUP_ASSIGNMENTS CCGA,

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
405: AND CCG.COST_GROUP_ID = i_cost_group_id

Line 433: CST_COST_GROUP_ASSIGNMENTS CCGA,

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
437: AND CCG.COST_GROUP_ID = i_cost_group_id

Line 622: cst_cost_group_assignments ccga,

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
626: rt.organization_id = ccga.organization_id AND