[Home] [Help]
219: po_headers_all phs,
220: -- po_releases_all prs, /*Bug 5443196*/
221: po_lines_all pls,
222: po_line_locations_all plls,
223: rcv_shipment_headers rsh,
224: rcv_shipment_lines rsl,
225: rcv_transactions rts
226: WHERE rts.shipment_header_id = rsh.shipment_header_id
227: AND rts.po_header_id = phs.po_header_id
297: po_headers_all phs,
298: po_releases_all prs,
299: po_lines_all pls,
300: po_line_locations_all plls,
301: rcv_shipment_headers rsh,
302: rcv_shipment_lines rsl,
303: rcv_transactions rts
304: WHERE rts.shipment_header_id = rsh.shipment_header_id
305: AND rts.po_header_id = phs.po_header_id
394: po_headers phs,
395: po_releases prs,
396: po_lines pls,
397: po_line_locations plls,
398: rcv_shipment_headers rsh,
399: rcv_shipment_lines rsl,
400: rcv_transactions rts
401: WHERE rts.shipment_header_id = rsh.shipment_header_id
402: AND rts.po_header_id = phs.po_header_id
462: X_curr_currency_code rcv_transactions.currency_code%TYPE := NULL;
463: X_curr_payment_terms_id NUMBER := NULL;
464: X_curr_transaction_date DATE := NULL;
465: X_curr_le_transaction_date DATE := NULL; --LE time zone date (Bug: 5205516)
466: X_curr_packing_slip rcv_shipment_headers.receipt_num%TYPE := NULL;
467: X_curr_shipment_header_id NUMBER := NULL;
468: X_curr_osa_flag VARCHAR2(1) := NULL; --Shikyu project
469:
470: X_curr_conversion_rate_type rcv_transactions.currency_conversion_type%TYPE;
533: /*Bug: 5125624*/
534: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
535: l_tax_classification_code VARCHAR2(30);
536:
537: X_curr_receipt_num rcv_shipment_headers.receipt_num%TYPE := NULL; /* bug 7512542 */
538: X_curr_por_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE := NULL; /* bug 7512542 */
539: X_curr_org_id NUMBER :=NULL; /* bug 7512542 */
540:
541: