APPS.POS_ASN_NOTIF dependencies on PO_VENDORS

Line 254: FROM POS_HEADERS_V poh,PO_VENDORS pov

250: BEGIN
251:
252: SELECT poh.expected_receipt_date
253: INTO h_expected_receipt_date_ts
254: FROM POS_HEADERS_V poh,PO_VENDORS pov
255: WHERE poh.shipment_num = x_shipment_num AND
256: poh.vendor_id = pov.vendor_id AND
257: poh.vendor_id = to_number(x_vendor_id) AND
258: poh.vendor_site_id = to_number(x_vendor_site_id);

Line 524: FROM pos_headers_v poh, po_vendors pov

520: poh.asn_type
521: INTO x_shipment_num,x_vendor_name,x_shipped_date,x_shipped_date_ts,
522: x_expected_receipt_date,x_expected_receipt_ts,x_invoice_num,x_total_invoice_amount,
523: x_invoice_ts,x_tax_amount,x_asn_type
524: FROM pos_headers_v poh, po_vendors pov
525: WHERE poh.shipment_num = x_shipment_num AND
526: poh.vendor_id = pov.vendor_id AND
527: poh.vendor_id = x_vendor_id AND
528: poh.vendor_site_id = x_vendor_site_id ;

Line 546: FROM POS_HEADERS_V poh,PO_VENDORS pov

542: x_expected_receipt_date,
543: x_expected_receipt_ts,
544: x_invoice_num,x_total_invoice_amount,
545: x_invoice_date,x_tax_amount,x_asn_type
546: FROM POS_HEADERS_V poh,PO_VENDORS pov
547: WHERE poh.shipment_num = x_shipment_num AND
548: poh.vendor_id = pov.vendor_id AND
549: poh.vendor_id = x_vendor_id AND
550: poh.vendor_site_id = x_vendor_site_id ;

Line 940: FROM POS_HEADERS_V poh,PO_VENDORS pov

936: h_invoice_num,h_total_invoice_amount,
937: h_invoice_date,
938: h_tax_amount,h_asn_type,
939: l_remit_to_site_id
940: FROM POS_HEADERS_V poh,PO_VENDORS pov
941: WHERE poh.shipment_num = x_shipment_num AND
942: poh.vendor_id = pov.vendor_id AND
943: poh.vendor_id = to_number(x_vendor_id) AND
944: poh.vendor_site_id = to_number(x_vendor_site_id);