APPS.POR_AMENDMENT_PKG dependencies on PO_LINE_LOCATIONS

Line 5212: -- po_line_locations_all pll,

5208: SELECT Min(awdrefs.agent_id)
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)

Line 5539: FROM po_releases_all pra,po_line_locations_all plla

5535:
5536: BEGIN
5537: SELECT Nvl(pra.authorization_status, 'INCOMPLETE')
5538: INTO l_authorization_status
5539: FROM po_releases_all pra,po_line_locations_all plla
5540: WHERE plla.line_location_id = l_line_location_id
5541: AND pra.po_release_id =plla.po_release_id ;
5542: EXCEPTION
5543: WHEN No_Data_Found THEN

Line 5553: po_line_locations_all plla

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;
5557: EXCEPTION

Line 5819: x_transaction_flow_header_id PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;

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;
5823: --

Line 5845: l_drop_ship_flag po_line_locations.drop_ship_flag%type; --bug#3603067

5841:
5842:
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

Line 5942: FROM po_line_locations_all PLL,

5938: x_po_header_id,
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:

Line 6050: po_line_locations_all pll --

6046:
6047: SELECT pol.unit_meas_lookup_code
6048: INTO x_po_uom
6049: FROM po_lines_all pol , --
6050: po_line_locations_all pll --
6051: WHERE pol.po_line_id = pll.po_line_id
6052: AND pll.line_location_id = x_line_location_id;
6053:
6054:

Line 6126: from po_line_locations_all where

6122: --!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
6123:
6124: begin
6125: select nvl(drop_ship_flag,'N') into l_drop_ship_flag
6126: from po_line_locations_all where
6127: line_location_id=x_line_location_id;
6128: exception
6129: when others then
6130: null;

Line 6346: FROM po_line_locations_all

6342: sysdate,
6343: FND_GLOBAL.USER_ID,
6344: FND_GLOBAL.LOGIN_ID,
6345: (SELECT po_line_id
6346: FROM po_line_locations_all
6347: WHERE line_location_id = x_line_location_id),
6348: x_line_location_id,
6349: nvl(x_po_release_id,''),
6350: x_requisition_dist_id,

Line 6486: FROM po_line_locations_all

6482: prd.oke_contract_line_id,
6483: prd.oke_contract_deliverable_id,
6484: g_purchasing_ou_id, --
6485: (SELECT shipment_type
6486: FROM po_line_locations_all
6487: WHERE line_location_id = x_line_location_id), --poll.shipment_type, --
6488: nvl2(g_calculate_tax_flag, 'CREATE', null), --
6489: null --pdi.interface_distribution_ref --
6490: -- <>