DBA Data[Home] [Help]

APPS.POR_AMENDMENT_PKG dependencies on PO_VENDORS

Line 1407: FROM po_vendors

1403: ELSIF label IN ('VENDOR_ID') THEN
1404:
1405: SELECT vendor_name
1406: INTO id
1407: FROM po_vendors
1408: WHERE vendor_id = p_id;
1409:
1410: ELSIF label IN ('VENDOR_SITE_ID') THEN
1411:

Line 5818: x_vendor_receipt_required_flag po_vendors.receipt_required_flag%type := NULL;

5814:
5815:
5816: --
5817: x_item_inspection_req_flag varchar2(1):=NULL;
5818: x_vendor_receipt_required_flag po_vendors.receipt_required_flag%type := NULL;
5819: x_transaction_flow_header_id PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;
5820: --
5821: l_uom_conversion_rate MTL_UOM_CONVERSIONS.conversion_rate%TYPE := 1;
5822: l_currency_conversion_rate PO_HEADERS_ALL.rate%TYPE := 1;

Line 6201: FROM po_vendors v

6197:
6198: BEGIN
6199: SELECT v.receipt_required_flag
6200: INTO x_vendor_receipt_required_flag
6201: FROM po_vendors v
6202: WHERE v.vendor_id = x_vendor_id;
6203:
6204:
6205: EXCEPTION