[Home] [Help]
229: po_headers_all phs,
230: -- po_releases_all prs, /*Bug 5443196*/
231: po_lines_all pls,
232: po_line_locations_all plls,
233: rcv_shipment_headers rsh,
234: rcv_shipment_lines rsl,
235: inl_ship_lines_all isl, -- PoR with LCM project
236: rcv_transactions rts
237: WHERE rts.shipment_header_id = rsh.shipment_header_id
324: po_headers_all phs,
325: po_releases_all prs,
326: po_lines_all pls,
327: po_line_locations_all plls,
328: rcv_shipment_headers rsh,
329: rcv_shipment_lines rsl,
330: inl_ship_lines_all isl, -- PoR with LCM project
331: rcv_transactions rts
332: WHERE rts.shipment_header_id = rsh.shipment_header_id
438: po_headers phs,
439: po_releases prs,
440: po_lines pls,
441: po_line_locations plls,
442: rcv_shipment_headers rsh,
443: rcv_shipment_lines rsl,
444: inl_ship_lines_all isl, -- PoR with LCM project
445: rcv_transactions rts
446: WHERE rts.shipment_header_id = rsh.shipment_header_id
513: X_curr_currency_code rcv_transactions.currency_code%TYPE := NULL;
514: X_curr_payment_terms_id NUMBER := NULL;
515: X_curr_transaction_date DATE := NULL;
516: X_curr_le_transaction_date DATE := NULL; --LE time zone date (Bug: 5205516)
517: X_curr_packing_slip rcv_shipment_headers.receipt_num%TYPE := NULL;
518: X_curr_shipment_header_id NUMBER := NULL;
519: X_curr_osa_flag VARCHAR2(1) := NULL; --Shikyu project
520:
521: X_curr_conversion_rate_type rcv_transactions.currency_conversion_type%TYPE;
584: /*Bug: 5125624*/
585: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
586: l_tax_classification_code VARCHAR2(30);
587:
588: X_curr_receipt_num rcv_shipment_headers.receipt_num%TYPE := NULL; /* bug 7512542 */
589: X_curr_por_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE := NULL; /* bug 7512542 */
590: X_curr_org_id NUMBER :=NULL; /* bug 7512542 */
591:
592: