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_SUPPERF_API_PKG dependencies on RCV_TRANSACTIONS

Line 6: -- This function returns the receipt date from rcv_transactions. There can

2: /* $Header: POASPAPB.pls 115.7 2003/12/09 09:04:34 bthammin ship $ */
3:
4: -- get_receipt_date
5: -- ----------------
6: -- This function returns the receipt date from rcv_transactions. There can
7: -- be multiple receipts for a single shipment, so we are only accounting for
8: -- the earliest receipt date
9: --
10: FUNCTION get_receipt_date(p_line_location_id NUMBER)

Line 21: FROM rcv_transactions

17: x_progress := '001';
18:
19: SELECT MIN(transaction_date)
20: INTO v_receipt_date
21: FROM rcv_transactions
22: WHERE po_line_location_id = p_line_location_id
23: AND transaction_type = 'RECEIVE';
24:
25: RETURN(v_receipt_date);

Line 157: FROM rcv_transactions

153: x_progress := '001';
154:
155: SELECT count(*)
156: INTO v_num_receipts
157: FROM rcv_transactions
158: WHERE po_line_location_id = p_line_location_id
159: AND transaction_type = 'RECEIVE';
160:
161: RETURN(v_num_receipts);

Line 200: FROM rcv_transactions

196: x_progress := '001';
197:
198: SELECT SUM(primary_quantity)
199: INTO v_txn_qty
200: FROM rcv_transactions
201: WHERE po_line_location_id = p_line_location_id
202: AND transaction_type = 'RECEIVE'
203: AND transaction_date - NVL(p_days_late_allowed, 0)
204: > p_expected_date;

Line 210: FROM rcv_transactions rcor,

206: x_progress := '002';
207:
208: SELECT SUM(rcor.primary_quantity)
209: INTO v_correction_qty
210: FROM rcv_transactions rcor,
211: rcv_transactions rct
212: WHERE rcor.po_line_location_id = p_line_location_id
213: AND rcor.transaction_type = 'CORRECT'
214: AND rct.transaction_id = rcor.parent_transaction_id

Line 211: rcv_transactions rct

207:
208: SELECT SUM(rcor.primary_quantity)
209: INTO v_correction_qty
210: FROM rcv_transactions rcor,
211: rcv_transactions rct
212: WHERE rcor.po_line_location_id = p_line_location_id
213: AND rcor.transaction_type = 'CORRECT'
214: AND rct.transaction_id = rcor.parent_transaction_id
215: AND rct.transaction_type = 'RECEIVE'

Line 260: FROM rcv_transactions

256: x_progress := '001';
257:
258: SELECT SUM(primary_quantity)
259: INTO v_txn_qty
260: FROM rcv_transactions
261: WHERE po_line_location_id = p_line_location_id
262: AND transaction_type = 'RECEIVE'
263: AND transaction_date + NVL(p_days_early_allowed, 0)
264: < p_expected_date;

Line 270: FROM rcv_transactions rcor,

266: x_progress := '002';
267:
268: SELECT SUM(rcor.primary_quantity)
269: INTO v_correction_qty
270: FROM rcv_transactions rcor,
271: rcv_transactions rct
272: WHERE rcor.po_line_location_id = p_line_location_id
273: AND rcor.transaction_type = 'CORRECT'
274: AND rct.transaction_id = rcor.parent_transaction_id

Line 271: rcv_transactions rct

267:
268: SELECT SUM(rcor.primary_quantity)
269: INTO v_correction_qty
270: FROM rcv_transactions rcor,
271: rcv_transactions rct
272: WHERE rcor.po_line_location_id = p_line_location_id
273: AND rcor.transaction_type = 'CORRECT'
274: AND rct.transaction_id = rcor.parent_transaction_id
275: AND rct.transaction_type = 'RECEIVE'

Line 706: -- - rcv_transactions - last_update_date

702: -- -----------------
703: -- This procedure returns the last update date for a particular
704: -- shipment line.
705: -- The dates considered are for:
706: -- - rcv_transactions - last_update_date
707: -- - po_line_locations_all - last_update_date
708: -- If any of these records changed after the last collection,
709: -- the shipment data need to be re-collected.
710: --

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

718:
719: x_progress := '001';
720:
721: --
722: -- Get max date from rcv_transactions, including corrections
723: --
724: BEGIN
725: SELECT MAX(last_update_date)
726: INTO v_max_rcv_date

Line 727: FROM rcv_transactions

723: --
724: BEGIN
725: SELECT MAX(last_update_date)
726: INTO v_max_rcv_date
727: FROM rcv_transactions
728: WHERE po_line_location_id = p_line_location_id;
729:
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN

Line 787: FROM rcv_transactions

783: x_progress := '002';
784:
785: SELECT SUM(primary_quantity)
786: INTO v_txn_qty
787: FROM rcv_transactions
788: WHERE po_line_location_id = p_line_location_id
789: AND transaction_type = p_txn_type;
790:
791: x_progress := '003';

Line 795: FROM rcv_transactions rcor,

791: x_progress := '003';
792:
793: SELECT SUM(rcor.primary_quantity)
794: INTO v_correction_qty
795: FROM rcv_transactions rcor,
796: rcv_transactions rct
797: WHERE rcor.po_line_location_id = p_line_location_id
798: AND rcor.transaction_type = 'CORRECT'
799: AND rct.transaction_id = rcor.parent_transaction_id

Line 796: rcv_transactions rct

792:
793: SELECT SUM(rcor.primary_quantity)
794: INTO v_correction_qty
795: FROM rcv_transactions rcor,
796: rcv_transactions rct
797: WHERE rcor.po_line_location_id = p_line_location_id
798: AND rcor.transaction_type = 'CORRECT'
799: AND rct.transaction_id = rcor.parent_transaction_id
800: AND rct.transaction_type = p_txn_type;