APPS.POS_ASN_NOTIF dependencies on PO_VENDORS

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 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);