DBA Data[Home] [Help]

APPS.INL_TAX_PVT dependencies on PO_LINE_LOCATIONS

Line 172: FROM po_line_locations pll,

168: l_amt,
169: l_po_curr_code,
170: l_po_curr_rate_type,
171: l_po_curr_rate_date
172: FROM po_line_locations pll,
173: po_lines_all pL,
174: po_headers pH
175: WHERE pll.line_location_id = p_po_line_location_id
176: AND pll.po_line_id = pL.po_line_id

Line 1030: FROM po_line_locations pll, po_headers ph

1026: x_return_status := FND_API.G_RET_STS_SUCCESS;
1027: -- get PO_Header_id
1028: SELECT pll.po_header_id, nvl(ph.rate ,1)
1029: INTO x_po_header_id, x_po_header_curr_conv_rate
1030: FROM po_line_locations pll, po_headers ph
1031: WHERE pll.line_location_id = P_Po_Line_Location_Id
1032: AND pll.po_header_id = ph.po_header_id
1033: AND rownum = 1;
1034:

Line 2481: po_line_locations pll

2477: x_prod_category,
2478: x_intended_use,
2479: x_product_type
2480: FROM zx_lines_det_factors zx,
2481: po_line_locations pll
2482: WHERE zx.application_id = 201
2483: AND zx.event_class_code = 'PO_PA'
2484: AND zx.entity_code = 'PURCHASE_ORDER'
2485: AND zx.trx_id = pll.po_header_id