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.POS_ASN_NOTIF dependencies on POS_HEADERS_V

Line 401: FROM POS_HEADERS_V poh,PO_VENDORS pov

397: x_expected_receipt_date,
398: x_expected_receipt_ts,
399: x_invoice_num,x_total_invoice_amount,
400: x_invoice_date,x_tax_amount,x_asn_type
401: FROM POS_HEADERS_V poh,PO_VENDORS pov
402: WHERE poh.shipment_num = x_shipment_num AND
403: poh.vendor_id = pov.vendor_id AND
404: poh.vendor_id = x_vendor_id AND
405: poh.vendor_site_id = x_vendor_site_id ;

Line 645: h_shipment_num pos_headers_v.shipment_num%TYPE;

641: x_num_lines NUMBER;
642: x_bvs_id VARCHAR2(50);
643: x_vs_id VARCHAR2(50);
644:
645: h_shipment_num pos_headers_v.shipment_num%TYPE;
646: h_asn_type VARCHAR2(20);
647: h_vendor_name VARCHAR2(240);
648: h_shipped_date varchar2(2000);
649: h_expected_receipt_date varchar2(2000);

Line 760: FROM POS_HEADERS_V poh,PO_VENDORS pov

756: h_invoice_num,h_total_invoice_amount,
757: h_invoice_date,
758: h_tax_amount,h_asn_type,
759: l_remit_to_site_id
760: FROM POS_HEADERS_V poh,PO_VENDORS pov
761: WHERE poh.shipment_num = x_shipment_num AND
762: poh.vendor_id = pov.vendor_id AND
763: poh.vendor_id = to_number(x_vendor_id) AND
764: poh.vendor_site_id = to_number(x_vendor_site_id);

Line 931: select count(*) into x_num_lines from pos_headers_v

927: -- End of Header Info
928:
929:
930: -- check if notification was cancelled then do not generate the table
931: select count(*) into x_num_lines from pos_headers_v
932: where shipment_num=x_shipment_num and
933: vendor_id = x_vendor_id and
934: vendor_site_id = x_vendor_site_id;
935: