DBA Data[Home] [Help]

APPS.PO_SHIPMENTS_SV4 dependencies on PO_HEADERS_ALL

Line 1061: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE;

1057: ,p_po_line_id IN NUMBER
1058: ,p_doc_subtype IN VARCHAR2)
1059: IS
1060:
1061: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE;
1062: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
1063: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1064: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1065: l_po_lines_rec PO_LINES_ALL%ROWTYPE;

Line 1062: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;

1058: ,p_doc_subtype IN VARCHAR2)
1059: IS
1060:
1061: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE;
1062: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
1063: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1064: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1065: l_po_lines_rec PO_LINES_ALL%ROWTYPE;
1066: l_base_unit_price PO_LINES_ALL.base_unit_price%TYPE;

Line 1063: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;

1059: IS
1060:
1061: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE;
1062: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
1063: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1064: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1065: l_po_lines_rec PO_LINES_ALL%ROWTYPE;
1066: l_base_unit_price PO_LINES_ALL.base_unit_price%TYPE;
1067: l_from_line_location_id PO_LINES_ALL.from_line_location_id%TYPE := NULL;

Line 1064: l_org_id PO_HEADERS_ALL.org_id%TYPE;

1060:
1061: l_vendor_id PO_HEADERS_ALL.vendor_id%TYPE;
1062: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
1063: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1064: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1065: l_po_lines_rec PO_LINES_ALL%ROWTYPE;
1066: l_base_unit_price PO_LINES_ALL.base_unit_price%TYPE;
1067: l_from_line_location_id PO_LINES_ALL.from_line_location_id%TYPE := NULL;
1068: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE := NULL;

Line 1125: FROM po_headers_all poh

1121: poh.currency_code
1122: INTO l_vendor_id,
1123: l_vendor_site_id,
1124: l_currency_code
1125: FROM po_headers_all poh
1126: WHERE poh.po_header_id = l_po_lines_rec.po_header_id;
1127:
1128: d_pos := 50;
1129: IF (PO_LOG.d_stmt) THEN