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.AP_IMPORT_VALIDATION_PKG dependencies on PO_AP_RECEIPT_MATCH_V

Line 14470: FROM po_ap_receipt_match_v

14466:
14467: BEGIN
14468: SELECT rcv_transaction_id
14469: INTO l_temp_rcv_txn_id
14470: FROM po_ap_receipt_match_v
14471: WHERE po_line_location_id = p_invoice_lines_rec.po_line_location_id;
14472:
14473: EXCEPTION
14474: When no_data_found THEN

Line 14508: FROM po_ap_receipt_match_v

14504:
14505: BEGIN
14506: SELECT rcv_transaction_id
14507: INTO l_temp_rcv_txn_id
14508: FROM po_ap_receipt_match_v
14509: WHERE receipt_number = p_invoice_lines_rec.receipt_number
14510: AND po_line_location_id = p_invoice_lines_rec.po_line_location_id;
14511:
14512: Exception

Line 14547: FROM po_ap_receipt_match_v

14543:
14544: BEGIN
14545: SELECT rcv_transaction_id
14546: INTO l_temp_rcv_txn_id
14547: FROM po_ap_receipt_match_v
14548: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id
14549: AND po_line_location_id = p_invoice_lines_rec.po_line_location_id;
14550:
14551: EXCEPTION

Line 14582: FROM po_ap_receipt_match_v

14578: END IF;
14579: BEGIN
14580: SELECT rcv_transaction_id
14581: INTO l_temp_rcv_txn_id
14582: FROM po_ap_receipt_match_v
14583: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id
14584: AND receipt_number = p_invoice_lines_rec.receipt_number
14585: AND po_line_location_id = p_invoice_lines_rec.po_line_location_id;
14586:

Line 14627: FROM po_ap_receipt_match_v

14623:
14624: BEGIN
14625: SELECT distinct receipt_uom_lookup_code
14626: INTO l_rcv_uom
14627: FROM po_ap_receipt_match_v
14628: WHERE po_line_location_id = p_invoice_lines_rec.po_line_location_id
14629: AND receipt_number = NVL(p_invoice_lines_rec.receipt_number,
14630: receipt_number)
14631: AND rcv_transaction_id = nvl(p_invoice_lines_rec.rcv_transaction_id,

Line 14773: FROM po_ap_receipt_match_v

14769: END IF;
14770: BEGIN
14771: SELECT rcv_transaction_id
14772: INTO l_temp_rcv_txn_id
14773: FROM po_ap_receipt_match_v
14774: WHERE receipt_number = p_invoice_lines_rec.receipt_number
14775: AND po_line_location_id = p_invoice_lines_rec.po_line_location_id;
14776:
14777: Exception

Line 14826: FROM po_ap_receipt_match_v

14822:
14823: BEGIN
14824: SELECT rcv_transaction_id
14825: INTO l_temp_rcv_txn_id
14826: FROM po_ap_receipt_match_v
14827: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id
14828: AND po_line_location_id = p_invoice_lines_rec.po_line_location_id;
14829:
14830: Exception

Line 14862: FROM po_ap_receipt_match_v

14858:
14859: BEGIN
14860: SELECT rcv_transaction_id
14861: INTO l_temp_rcv_txn_id
14862: FROM po_ap_receipt_match_v
14863: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id
14864: AND receipt_number = p_invoice_lines_rec.receipt_number
14865: AND po_line_location_id = p_invoice_lines_rec.po_line_location_id;
14866:

Line 14911: FROM po_ap_receipt_match_v

14907: END IF;
14908: BEGIN
14909: SELECT rcv_transaction_id
14910: INTO l_temp_rcv_txn_id
14911: FROM po_ap_receipt_match_v
14912: WHERE receipt_number = p_invoice_lines_rec.receipt_number;
14913: Exception
14914: When no_data_found THEN
14915: --reject fOR INVALID RECEIPT INFORMATION

Line 14961: FROM po_ap_receipt_match_v

14957: END IF;
14958: BEGIN
14959: SELECT rcv_transaction_id
14960: INTO l_temp_rcv_txn_id
14961: FROM po_ap_receipt_match_v
14962: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id;
14963: Exception
14964: When Others THEN
14965: -- reject fOR INVALID RECEIPT INFORMATION

Line 14994: FROM po_ap_receipt_match_v

14990: END IF;
14991: BEGIN
14992: SELECT rcv_transaction_id
14993: INTO l_temp_rcv_txn_id
14994: FROM po_ap_receipt_match_v
14995: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id
14996: AND receipt_number = p_invoice_lines_rec.receipt_number;
14997: Exception
14998: When Others THEN

Line 15034: FROM po_ap_receipt_match_v

15030: END IF;
15031: BEGIN
15032: SELECT rcv_shipment_line_id
15033: INTO l_temp_ship_line_id
15034: FROM po_ap_receipt_match_v
15035: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id;
15036: Exception
15037: When no_data_found THEN
15038: --reject fOR INVALID RECEIPT INFORMATION

Line 15122: FROM po_ap_receipt_match_v

15118: END IF;
15119: BEGIN
15120: SELECT 'Y'
15121: INTO l_temp_value
15122: FROM po_ap_receipt_match_v
15123: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id
15124: AND receipt_uom_lookup_code =
15125: p_invoice_lines_rec.unit_of_meas_lookup_code;
15126: EXCEPTION