DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_VALIDATIONS dependencies on RCV_SHIPMENT_HEADERS

Line 3329: l_shipment_header_id RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE;

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;
3332: l_match_exists VARCHAR2(1);
3333: l_unpaid_invoices_exists VARCHAR2(1);

Line 3330: l_receipt_num RCV_SHIPMENT_HEADERS.receipt_num%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;
3332: l_match_exists VARCHAR2(1);
3333: l_unpaid_invoices_exists VARCHAR2(1);
3334: l_unval_invoice_exists VARCHAR2(1);

Line 3401: ,rcv_shipment_headers rcvh

3397: INTO l_shipment_header_id
3398: ,l_receipt_num
3399: ,l_receipt_date
3400: FROM rcv_shipment_lines rcvl
3401: ,rcv_shipment_headers rcvh
3402: , rcv_transactions rt
3403: WHERE rcvl.shipment_header_id = rcvh.shipment_header_id
3404: AND rt.shipment_header_id = rcvh.shipment_header_id
3405: AND rt.transaction_type IN ('RECEIVE', 'MATCH')