[Home] [Help]
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
164: the organization_id in MMT. In this case, the org_cost_group
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
245: mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id) AND
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
275: ccg.cost_group_id = i_cost_group_id AND
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
307: NVL(rt.consigned_flag,'N') = 'N' AND
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
362: rae.rcv_transaction_id = rt.transaction_id AND
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
406: AND CCG.LEGAL_ENTITY = i_legal_entity
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
438: AND CCG.LEGAL_ENTITY = i_legal_entity
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
627: NVL(rt.consigned_flag,'N') = 'N' AND