DBA Data[Home] [Help]

APPS.AHL_OSP_COST_PVT dependencies on PO_HEADERS

Line 59: from po_lines_all pol, po_headers_all po

55: /** End change by jaramana on January 11, 2008 for the Requisition ER 6034236 **/
56:
57: CURSOR get_po_line_price_csr(p_po_line_id IN NUMBER) IS
58: SELECT pol.unit_price*pol.quantity extended_price, po.currency_code
59: from po_lines_all pol, po_headers_all po
60: WHERE po_line_id = p_po_line_id
61: AND pol.po_header_id = po.po_header_id;
62:
63: /** Added by jaramana on January 11, 2008 for the Requisition ER 6034236 **/

Line 77: l_po_currency_code po_headers.currency_code%type := null;

73: where COD.Organization_Id = p_org_id
74: AND LEDGER_ID = GSOB.SET_OF_BOOKS_ID
75: AND NVL(operating_unit, mo_global.get_current_org_id())= mo_global.get_current_org_id();
76:
77: l_po_currency_code po_headers.currency_code%type := null;
78: l_ou_currency_code gl_sets_of_books.currency_code%type := null;
79:
80: /* commented out since workorder org should be the same as osp line org
81: