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.POA_EDW_SUPPERF dependencies on RCV_TRANSACTIONS

Line 156: FROM rcv_transactions

152: BEGIN
153:
154: SELECT MIN(transaction_date)
155: INTO v_receipt_date
156: FROM rcv_transactions
157: WHERE po_line_location_id = p_line_location_id
158: AND transaction_type = 'RECEIVE';
159:
160: RETURN(v_receipt_date);

Line 177: -- - rcv_transactions - last_update_date for any transaction type

173: -- get_last_rcv_trx_date
174: --
175: -- Returns the last transaction date for a particular shipment.
176: -- The dates considered are for:
177: -- - rcv_transactions - last_update_date for any transaction type
178: -- - rcv_shipment_lines - last_update_date
179: -- We should look at last_update_date instead of transaction_date for
180: -- rcv_transactions because the transaction_date can be in the past, but
181: -- the data would not be collected yet since it didn't exist then.

Line 180: -- rcv_transactions because the transaction_date can be in the past, but

176: -- The dates considered are for:
177: -- - rcv_transactions - last_update_date for any transaction type
178: -- - rcv_shipment_lines - last_update_date
179: -- We should look at last_update_date instead of transaction_date for
180: -- rcv_transactions because the transaction_date can be in the past, but
181: -- the data would not be collected yet since it didn't exist then.
182: --
183: -- If any of these dates changed the data from the Supplier Performance
184: -- source view need to be re-collected.

Line 196: -- Get max date from rcv_transactions, including corrections

192: v_line_loc_date DATE := NULL;
193: BEGIN
194:
195: --
196: -- Get max date from rcv_transactions, including corrections
197: --
198: BEGIN
199: SELECT MAX(last_update_date)
200: INTO v_max_rcv_trx_date

Line 201: FROM rcv_transactions

197: --
198: BEGIN
199: SELECT MAX(last_update_date)
200: INTO v_max_rcv_trx_date
201: FROM rcv_transactions
202: WHERE po_line_location_id = p_line_location_id;
203:
204: EXCEPTION
205: WHEN NO_DATA_FOUND THEN

Line 403: FROM rcv_transactions rct

399: sum(1)
400: INTO
401: l_qty_rec_cnt_early, l_qty_rec_cnt_late, l_qty_rec_cnt_early_window, l_qty_rec_cnt_late_window, l_qty_rec_cnt_ondate, l_qty_rec_cnt_substitute,
402: l_qty_rec_cnt_all, l_qty_rec_num_early, l_qty_rec_num_late, l_qty_rec_num_early_window, l_qty_rec_num_late_window, l_qty_rec_num_ondate, l_qty_rec_num_substitute, l_qty_rec_num_all
403: FROM rcv_transactions rct
404: WHERE rct.po_line_location_id = p_line_location_id
405: AND rct.transaction_type = 'RECEIVE';
406:
407: END IF;

Line 424: FROM rcv_transactions rcor,

420: sum(decode(rct.substitute_unordered_code, 'SUBSTITUTE', rcor.source_doc_quantity, 0)),
421: sum(rcor.source_doc_quantity)
422: INTO
423: l_qty_rec_cnt_cor_early, l_qty_rec_cnt_cor_late, l_qty_rec_cnt_cor_early_window, l_qty_rec_cnt_cor_late_window, l_qty_rec_cnt_cor_ondate, l_qty_rec_cnt_cor_substitute, l_qty_rec_cnt_cor_all
424: FROM rcv_transactions rcor,
425: rcv_transactions rct
426: WHERE rcor.po_line_location_id = p_line_location_id
427: AND rcor.transaction_type = 'CORRECT'
428: AND rct.transaction_id = rcor.parent_transaction_id

Line 425: rcv_transactions rct

421: sum(rcor.source_doc_quantity)
422: INTO
423: l_qty_rec_cnt_cor_early, l_qty_rec_cnt_cor_late, l_qty_rec_cnt_cor_early_window, l_qty_rec_cnt_cor_late_window, l_qty_rec_cnt_cor_ondate, l_qty_rec_cnt_cor_substitute, l_qty_rec_cnt_cor_all
424: FROM rcv_transactions rcor,
425: rcv_transactions rct
426: WHERE rcor.po_line_location_id = p_line_location_id
427: AND rcor.transaction_type = 'CORRECT'
428: AND rct.transaction_id = rcor.parent_transaction_id
429: AND rct.transaction_type = 'RECEIVE';

Line 617: FROM rcv_transactions rct

613: sum(1)
614: INTO
615: l_qty_rec_cnt_early, l_qty_rec_cnt_late, l_qty_rec_cnt_early_window, l_qty_rec_cnt_late_window, l_qty_rec_cnt_ondate, l_qty_rec_cnt_substitute,
616: l_qty_rec_cnt_all, l_qty_rec_num_early, l_qty_rec_num_late, l_qty_rec_num_early_window, l_qty_rec_num_late_window, l_qty_rec_num_ondate, l_qty_rec_num_substitute, l_qty_rec_num_all
617: FROM rcv_transactions rct
618: WHERE rct.po_line_location_id = p_line_location_id
619: AND rct.transaction_type = 'RECEIVE';
620:
621: END IF;

Line 655: FROM rcv_transactions rcor,

651: sum(decode(rct.substitute_unordered_code, 'SUBSTITUTE', 1, 0)),
652: sum(1)
653: INTO
654: l_qty_rec_num_cor_early, l_qty_rec_num_cor_late, l_qty_rec_num_cor_early_window, l_qty_rec_num_cor_late_window, l_qty_rec_num_cor_ondate, l_qty_rec_num_cor_substitute, l_qty_rec_num_cor_all
655: FROM rcv_transactions rcor,
656: rcv_transactions rct
657: WHERE rcor.po_line_location_id = p_line_location_id
658: AND rcor.transaction_type = 'CORRECT'
659: AND rct.transaction_id = rcor.parent_transaction_id

Line 656: rcv_transactions rct

652: sum(1)
653: INTO
654: l_qty_rec_num_cor_early, l_qty_rec_num_cor_late, l_qty_rec_num_cor_early_window, l_qty_rec_num_cor_late_window, l_qty_rec_num_cor_ondate, l_qty_rec_num_cor_substitute, l_qty_rec_num_cor_all
655: FROM rcv_transactions rcor,
656: rcv_transactions rct
657: WHERE rcor.po_line_location_id = p_line_location_id
658: AND rcor.transaction_type = 'CORRECT'
659: AND rct.transaction_id = rcor.parent_transaction_id
660: AND rct.transaction_type = 'RECEIVE'

Line 856: FROM rcv_transactions

852: x_progress := '002';
853:
854: SELECT SUM(source_doc_quantity)
855: INTO v_txn_qty
856: FROM rcv_transactions
857: WHERE po_line_location_id = p_line_location_id
858: AND transaction_type = p_txn_type;
859:
860: x_progress := '003';

Line 864: FROM rcv_transactions rcor,

860: x_progress := '003';
861:
862: SELECT SUM(rcor.source_doc_quantity)
863: INTO v_correction_qty
864: FROM rcv_transactions rcor,
865: rcv_transactions rct
866: WHERE rcor.po_line_location_id = p_line_location_id
867: AND rcor.transaction_type = 'CORRECT'
868: AND rct.transaction_id = rcor.parent_transaction_id

Line 865: rcv_transactions rct

861:
862: SELECT SUM(rcor.source_doc_quantity)
863: INTO v_correction_qty
864: FROM rcv_transactions rcor,
865: rcv_transactions rct
866: WHERE rcor.po_line_location_id = p_line_location_id
867: AND rcor.transaction_type = 'CORRECT'
868: AND rct.transaction_id = rcor.parent_transaction_id
869: AND rct.transaction_type = p_txn_type;