eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPALPC dependencies on RCV_TRANSACTIONS

Line 274: rcv_transactions rt,

270: plc.lookup_code "EVENT_TYPE", --4968702 Directly taking data from mfg_lookup_codes instead of view caet
271: 'RCV' "TRANSACTION_TYPE_FLAG", -- 4968702
272: NULL "TRX_SOURCE_LINE_ID"
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

Line 295: (select rt2.transaction_id from rcv_transactions rt2

291: rt.source_document_code = 'PO' AND
292: ((rt.transaction_type = 'RECEIVE' AND rt.parent_transaction_id = -1)
293: OR (rt.transaction_type in ('MATCH','RETURN TO VENDOR','RETURN TO RECEIVING','DELIVER'))
294: OR (rt.transaction_type = 'CORRECT' and rt.parent_transaction_id IN
295: (select rt2.transaction_id from rcv_transactions rt2
296: where
297: (rt2.transaction_type = 'RECEIVE' AND rt2.parent_transaction_id = -1) OR
298: (rt2.transaction_type in ('RETURN TO VENDOR','RETURN TO RECEIVING','MATCH','DELIVER'))
299: )

Line 329: rcv_transactions rt,

325: 'RAE' "TRANSACTION_TYPE_FLAG", -- Bug 4968702
326: NULL "TRX_SOURCE_LINE_ID"
327: FROM
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:

Line 374: RCV_TRANSACTIONS RT,

370: 'ADJUST RECEIVE' "EVENT_TYPE",
371: 'ADJ' "TRANSACTION_TYPE_FLAG",
372: NULL "TRX_SOURCE_LINE_ID"
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

Line 406: RCV_TRANSACTIONS RT,

402: 20,'PAC LC ADJ DEL EXP') "EVENT_TYPE",
403: 'LC ADJ' "TRANSACTION_TYPE_FLAG",
404: NULL "TRX_SOURCE_LINE_ID"
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

Line 595: rcv_transactions rt,

591: rt.transaction_type "TRANSACTION_TYPE",
592: caet.event_type "EVENT_TYPE",
593: caet.transaction_type_flag "TRANSACTION_TYPE_FLAG"
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