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.PO_MULTI_MOD_VALIDATIONS dependencies on PO_LINE_LOCATIONS_ALL

Line 3325: l_match_option PO_LINE_LOCATIONS_ALL.match_option%TYPE;

3321: l_results_count NUMBER;
3322: d_mod CONSTANT VARCHAR2(100) := D_generate_receipts_exceptions;
3323: d_position NUMBER := 0;
3324: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
3325: l_match_option PO_LINE_LOCATIONS_ALL.match_option%TYPE;
3326: l_inspection_required_flag PO_LINE_LOCATIONS_ALL.inspection_required_flag%TYPE;
3327: l_receipt_required_flag PO_LINE_LOCATIONS_ALL.receipt_required_flag%TYPE;
3328: l_shipment_line_id_tbl PO_TBL_NUMBER;
3329: l_shipment_header_id RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE;

Line 3326: l_inspection_required_flag PO_LINE_LOCATIONS_ALL.inspection_required_flag%TYPE;

3322: d_mod CONSTANT VARCHAR2(100) := D_generate_receipts_exceptions;
3323: d_position NUMBER := 0;
3324: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
3325: l_match_option PO_LINE_LOCATIONS_ALL.match_option%TYPE;
3326: l_inspection_required_flag PO_LINE_LOCATIONS_ALL.inspection_required_flag%TYPE;
3327: l_receipt_required_flag PO_LINE_LOCATIONS_ALL.receipt_required_flag%TYPE;
3328: l_shipment_line_id_tbl PO_TBL_NUMBER;
3329: l_shipment_header_id RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE;
3330: l_receipt_num RCV_SHIPMENT_HEADERS.receipt_num%TYPE;

Line 3327: l_receipt_required_flag PO_LINE_LOCATIONS_ALL.receipt_required_flag%TYPE;

3323: d_position NUMBER := 0;
3324: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
3325: l_match_option PO_LINE_LOCATIONS_ALL.match_option%TYPE;
3326: l_inspection_required_flag PO_LINE_LOCATIONS_ALL.inspection_required_flag%TYPE;
3327: l_receipt_required_flag PO_LINE_LOCATIONS_ALL.receipt_required_flag%TYPE;
3328: l_shipment_line_id_tbl PO_TBL_NUMBER;
3329: l_shipment_header_id RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE;
3330: l_receipt_num RCV_SHIPMENT_HEADERS.receipt_num%TYPE;
3331: l_invoice_id AP_INVOICE_LINES_ALL.invoice_id%TYPE;

Line 3413: po_line_locations_all poll,

3409:
3410: SELECT Nvl(Sum(Nvl(rsl.quantity_received, 0) * NVL(poll.price_override, pol.unit_price) ), 0)
3411: INTO l_receipt_amount
3412: FROM rcv_shipment_lines rsl,
3413: po_line_locations_all poll,
3414: po_lines_all pol
3415: WHERE rsl.po_line_location_id = poll.line_location_id
3416: AND rsl.po_line_id = pol.po_line_id
3417: AND pol.po_line_id = poll.po_line_id

Line 3531: FROM po_line_locations_all

3527: ,receipt_required_flag
3528: INTO l_match_option
3529: ,l_inspection_required_flag
3530: ,l_receipt_required_flag
3531: FROM po_line_locations_all
3532: WHERE po_header_id = l_results.document_id(i) /*Bug 13055377 - the wrong document_id was being passes and hence the proper exceptions were not shown.passing the correct documemt_id*/
3533: AND match_option='R' -- Bug 13690746 - get the first shipment with match_option 'R'
3534: AND ROWNUM =1; -- Bug 13690746 - get the first shipment with match_option 'R'
3535: