eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_AMENDMENT_PKG dependencies on PO_HEADERS_ALL

Line 5213: -- po_headers_all pha

5209: INTO l_buyer_id
5210: FROM po_requisition_lines_all prl,
5211: PO_CLMREQ_LINE_AWD_REFS_V awdrefs
5212: -- po_line_locations_all pll,
5213: -- po_headers_all pha
5214: WHERE prl.requisition_header_id = (SELECT conformed_header_id
5215: FROM po_requisition_headers_all
5216: WHERE requisition_header_id = l_document_id)
5217: AND awdrefs.requisition_line_id = prl.requisition_line_id

Line 5517: l_authorization_status po_headers_all.authorization_status%TYPE;

5513: FUNCTION isLinePlacedOnApprPO(reqLineId IN NUMBER) RETURN VARCHAR2
5514: IS
5515: isApprovedPOLine VARCHAR2(1):='N';
5516: l_line_location_id NUMBER;
5517: l_authorization_status po_headers_all.authorization_status%TYPE;
5518: BEGIN
5519: SELECT line_location_id
5520: INTO l_line_location_id
5521: FROM po_requisition_lines_all

Line 5552: FROM po_headers_all pha,

5548: IF l_authorization_status IS NULL THEN
5549: BEGIN
5550: SELECT pha.authorization_status
5551: INTO l_authorization_status
5552: FROM po_headers_all pha,
5553: po_line_locations_all plla
5554: WHERE
5555: pha.po_header_id = plla.po_header_id
5556: AND plla.line_location_id = l_line_location_id;

Line 5784: x_po_currency_code PO_HEADERS_ALL.currency_code%TYPE;

5780:
5781: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
5782: x_req_rate_date PO_REQUISITION_LINES_ALL.rate_date%TYPE;
5783: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
5784: x_po_currency_code PO_HEADERS_ALL.currency_code%TYPE;
5785: x_pcard_id PO_HEADERS_ALL.pcard_id%TYPE;
5786: x_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
5787: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
5788: x_req_quantity PO_REQUISITION_LINES_ALL.quantity%TYPE;

Line 5785: x_pcard_id PO_HEADERS_ALL.pcard_id%TYPE;

5781: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
5782: x_req_rate_date PO_REQUISITION_LINES_ALL.rate_date%TYPE;
5783: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
5784: x_po_currency_code PO_HEADERS_ALL.currency_code%TYPE;
5785: x_pcard_id PO_HEADERS_ALL.pcard_id%TYPE;
5786: x_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
5787: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
5788: x_req_quantity PO_REQUISITION_LINES_ALL.quantity%TYPE;
5789: x_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;

Line 5786: x_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

5782: x_req_rate_date PO_REQUISITION_LINES_ALL.rate_date%TYPE;
5783: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
5784: x_po_currency_code PO_HEADERS_ALL.currency_code%TYPE;
5785: x_pcard_id PO_HEADERS_ALL.pcard_id%TYPE;
5786: x_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
5787: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
5788: x_req_quantity PO_REQUISITION_LINES_ALL.quantity%TYPE;
5789: x_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
5790: x_req_base_unit_price PO_REQUISITION_LINES_ALL.base_unit_price%TYPE;

Line 5822: l_currency_conversion_rate PO_HEADERS_ALL.rate%TYPE := 1;

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;
5823: --
5824: --
5825:
5826: g_purchasing_ou_id PO_HEADERS_ALL.org_id%TYPE;

Line 5826: g_purchasing_ou_id PO_HEADERS_ALL.org_id%TYPE;

5822: l_currency_conversion_rate PO_HEADERS_ALL.rate%TYPE := 1;
5823: --
5824: --
5825:
5826: g_purchasing_ou_id PO_HEADERS_ALL.org_id%TYPE;
5827: x_po_rate_type PO_HEADERS_ALL.rate_type%TYPE;
5828: x_po_rate_date PO_HEADERS_ALL.rate_date%TYPE;
5829: g_document_subtype varchar2(25);
5830: g_calculate_tax_flag VARCHAR2(1):= 'Y';

Line 5827: x_po_rate_type PO_HEADERS_ALL.rate_type%TYPE;

5823: --
5824: --
5825:
5826: g_purchasing_ou_id PO_HEADERS_ALL.org_id%TYPE;
5827: x_po_rate_type PO_HEADERS_ALL.rate_type%TYPE;
5828: x_po_rate_date PO_HEADERS_ALL.rate_date%TYPE;
5829: g_document_subtype varchar2(25);
5830: g_calculate_tax_flag VARCHAR2(1):= 'Y';
5831:

Line 5828: x_po_rate_date PO_HEADERS_ALL.rate_date%TYPE;

5824: --
5825:
5826: g_purchasing_ou_id PO_HEADERS_ALL.org_id%TYPE;
5827: x_po_rate_type PO_HEADERS_ALL.rate_type%TYPE;
5828: x_po_rate_date PO_HEADERS_ALL.rate_date%TYPE;
5829: g_document_subtype varchar2(25);
5830: g_calculate_tax_flag VARCHAR2(1):= 'Y';
5831:
5832: --

Line 5847: l_from_type_lookup_code po_headers_all.TYPE_LOOKUP_CODE%type;

5843:
5844: l_amount_ordered NUMBER; --!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
5845: l_drop_ship_flag po_line_locations.drop_ship_flag%type; --bug#3603067
5846: -- bug 5208159
5847: l_from_type_lookup_code po_headers_all.TYPE_LOOKUP_CODE%type;
5848:
5849: --introduced to hold the value of drop_ship_flag for shipments
5850: BEGIN
5851:

Line 5943: po_headers_all PHA

5939: x_po_rate_type,
5940: x_po_rate_date,
5941: x_transaction_flow_header_id
5942: FROM po_line_locations_all PLL,
5943: po_headers_all PHA
5944: WHERE PLL.po_header_id = PHA.po_header_id
5945: AND PLL.line_location_id = x_line_location_id;
5946:
5947: EXCEPTION