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 300: rcv_transactions rt,

296: plc.lookup_code "EVENT_TYPE", --4968702 Directly taking data from mfg_lookup_codes instead of view caet
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

Line 321: (select rt2.transaction_id from rcv_transactions rt2

317: rt.source_document_code = 'PO' AND
318: ((rt.transaction_type = 'RECEIVE' AND rt.parent_transaction_id = -1)
319: OR (rt.transaction_type in ('MATCH','RETURN TO VENDOR','RETURN TO RECEIVING','DELIVER'))
320: OR (rt.transaction_type = 'CORRECT' and rt.parent_transaction_id IN
321: (select rt2.transaction_id from rcv_transactions rt2
322: where
323: (rt2.transaction_type = 'RECEIVE' AND rt2.parent_transaction_id = -1) OR
324: (rt2.transaction_type in ('RETURN TO VENDOR','RETURN TO RECEIVING','MATCH','DELIVER'))
325: )

Line 355: rcv_transactions rt,

351: 'RAE' "TRANSACTION_TYPE_FLAG", -- Bug 4968702
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:

Line 399: RCV_TRANSACTIONS RT,

395: 'ADJUST RECEIVE' "EVENT_TYPE",
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

Line 431: RCV_TRANSACTIONS RT,

427: 20,'PAC LC ADJ DEL EXP') "EVENT_TYPE",
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

Line 620: rcv_transactions rt,

616: rt.transaction_type "TRANSACTION_TYPE",
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