APPS.JAI_OM_RG_PKG dependencies on OE_ORDER_LINES_ALL

Line 1214: FROM oe_order_lines_all

1210: -- cursor to get order source id, when 10 this means that it is an internal sales order(iso)
1211: -- this also gets other details to link to requisition side and the from org id.
1212: CURSOR c_get_order_details(p_header_id NUMBER, p_line_id NUMBER) IS
1213: SELECT ship_from_org_id, order_source_id, source_document_id, source_document_line_id
1214: FROM oe_order_lines_all
1215: WHERE header_id = p_header_id
1216: AND line_id = p_line_id;
1217:
1218: -- get the to organization id from the requisition details

Line 1822: v_order_line_id oe_order_lines_all.line_id%type;

1818:
1819: v_set_of_books_id NUMBER; /*Added by nprashar for bug # 11812969 */
1820:
1821: v_order_header_id oe_order_headers_all.header_id%type; /*Added by nprashar for bug # 11812969 */
1822: v_order_line_id oe_order_lines_all.line_id%type;
1823: v_currency_code OE_ORDER_HEADERS_ALL.TRANSACTIONAL_CURR_CODE%TYPE ; /*Added by nprashar for bug # 11812969 */
1824: v_conv_type_code OE_ORDER_HEADERS_ALL.CONVERSION_TYPE_CODE%TYPE ;
1825: v_conv_rate NUMBER ;
1826: v_conv_date DATE ;

Line 1838: oe_order_lines_all b

1834: conversion_rate ,
1835: b.actual_shipment_date
1836: FROM
1837: oe_order_headers_all a ,
1838: oe_order_lines_all b
1839: WHERE
1840: a.header_id = b.header_id AND
1841: b.line_id = p_line_id AND
1842: a.header_id = p_header_id ;

Line 1846: JAI_OM_OE_GEN_TAXINV_T temp , oe_order_lines_all oola

1842: a.header_id = p_header_id ;
1843:
1844: Cursor get_order_info(p_delivery_detail_id number) is /*Added by nprashar for bug # 11812969 */
1845: Select temp.order_header_id, oola.line_id from
1846: JAI_OM_OE_GEN_TAXINV_T temp , oe_order_lines_all oola
1847: where temp.order_header_id = oola.header_id
1848: and temp.delivery_detail_id = p_delivery_detail_id;
1849:
1850: CURSOR c_exc_exempt_dtls(p_delivery_detail_id IN NUMBER) IS

Line 3796: FROM oe_order_lines_all

3792: -- cursor to get order source id, when 10 this means that it is an internal sales order(iso)
3793: -- this also gets other details to link to requisition side and the from org id.
3794: CURSOR c_get_order_details(p_header_id NUMBER, p_line_id NUMBER) IS
3795: SELECT ship_from_org_id, order_source_id, source_document_id, source_document_line_id
3796: FROM oe_order_lines_all
3797: WHERE header_id = p_header_id
3798: AND line_id = p_line_id;
3799:
3800: -- get the to organization id from the requisition details

Line 4448: from oe_order_lines_all

4444:
4445: Cursor get_ref_header_line_id(cp_line_id number)
4446: is
4447: select reference_header_id , reference_line_id
4448: from oe_order_lines_all
4449: where line_id= cp_line_id;
4450:
4451: Cursor get_rma_delivery_id (cp_ref_header_id number,cp_ref_line_id number)
4452: is