APPS.POS_ASN_NOTIF dependencies on POS_HEADERS_V

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 811: h_shipment_num pos_headers_v.shipment_num%TYPE;

807: x_num_lines NUMBER;
808: x_bvs_id VARCHAR2(50);
809: x_vs_id VARCHAR2(50);
810:
811: h_shipment_num pos_headers_v.shipment_num%TYPE;
812: h_asn_type VARCHAR2(20);
813: h_vendor_name VARCHAR2(240);
814: h_shipped_date varchar2(2000);
815: h_expected_receipt_date varchar2(2000);

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

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

1154: -- End of Header Info
1155:
1156:
1157: -- check if notification was cancelled then do not generate the table
1158: select count(*) into x_num_lines from pos_headers_v
1159: where shipment_num=x_shipment_num and
1160: vendor_id = x_vendor_id and
1161: vendor_site_id = x_vendor_site_id;
1162: