DBA Data[Home] [Help]

APPS.CSTPALPC dependencies on CST_PAC_PERIODS

Line 160: cst_pac_periods cpp,

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

Line 245: cst_pac_periods cpp

241: FROM
242: wip_transactions wt,
243: cst_cost_groups ccg,
244: cst_cost_group_assignments ccga,
245: cst_pac_periods cpp
246: WHERE
247: wt.organization_id = ccga.organization_id AND
248: ccga.cost_group_id = ccg.cost_group_id AND
249: ccg.cost_group_id = i_cost_group_id AND

Line 277: cst_pac_periods cpp,

273: FROM
274: rcv_transactions rt,
275: cst_cost_groups ccg,
276: cst_cost_group_assignments ccga,
277: cst_pac_periods cpp,
278: po_lookup_codes plc
279: WHERE
280: rt.organization_id = ccga.organization_id AND
281: NVL(rt.consigned_flag,'N') = 'N' AND

Line 332: cst_pac_periods cpp

328: rcv_accounting_events rae,
329: rcv_transactions rt,
330: cst_cost_groups ccg,
331: cst_cost_group_assignments ccga,
332: cst_pac_periods cpp
333:
334: WHERE
335: rae.organization_id = ccga.organization_id AND
336: rae.rcv_transaction_id = rt.transaction_id AND

Line 377: CST_PAC_PERIODS CPP

373: FROM RCV_ACCOUNTING_EVENTS RAE,
374: RCV_TRANSACTIONS RT,
375: CST_COST_GROUPS CCG,
376: CST_COST_GROUP_ASSIGNMENTS CCGA,
377: CST_PAC_PERIODS CPP
378: WHERE RAE.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
379: AND CCGA.COST_GROUP_ID = CCG.COST_GROUP_ID
380: AND CCG.COST_GROUP_ID = i_cost_group_id
381: AND CCG.LEGAL_ENTITY = i_legal_entity

Line 409: CST_PAC_PERIODS CPP

405: FROM RCV_ACCOUNTING_EVENTS RAE,
406: RCV_TRANSACTIONS RT,
407: CST_COST_GROUPS CCG,
408: CST_COST_GROUP_ASSIGNMENTS CCGA,
409: CST_PAC_PERIODS CPP
410: WHERE RAE.ORGANIZATION_ID = CCGA.ORGANIZATION_ID
411: AND CCGA.COST_GROUP_ID = CCG.COST_GROUP_ID
412: AND CCG.COST_GROUP_ID = i_cost_group_id
413: AND CCG.LEGAL_ENTITY = i_legal_entity

Line 598: cst_pac_periods cpp,

594: FROM
595: rcv_transactions rt,
596: cst_cost_groups ccg,
597: cst_cost_group_assignments ccga,
598: cst_pac_periods cpp,
599: cst_accounting_event_types_v caet
600: WHERE
601: rt.organization_id = ccga.organization_id AND
602: NVL(rt.consigned_flag,'N') = 'N' AND