APPS.JAI_OM_RG_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 1187: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;

1183: )
1184: IS
1185: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
1186: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
1187: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
1188: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
1189: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
1190: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1191: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;

Line 1821: v_order_header_id oe_order_headers_all.header_id%type; /*Added by nprashar for bug # 11812969 */

1817: l_func_curr_det jai_plsql_cache_pkg.func_curr_details; /*Added by nprashar for bug # 11812969 */
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 ;

Line 1823: v_currency_code OE_ORDER_HEADERS_ALL.TRANSACTIONAL_CURR_CODE%TYPE ; /*Added by nprashar for bug # 11812969 */

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 ;
1827: v_order_number NUMBER ;

Line 1824: v_conv_type_code OE_ORDER_HEADERS_ALL.CONVERSION_TYPE_CODE%TYPE ;

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 ;
1827: v_order_number NUMBER ;
1828:

Line 1837: oe_order_headers_all a ,

1833: conversion_type_code ,
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

Line 3862: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;

3858: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;/*Bug 5989740 bduvarag*/
3859: ln_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE;
3860: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
3861: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
3862: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
3863: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
3864: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
3865: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3866: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;

Line 4349: from oe_order_headers_all

4345:
4346:
4347: cursor c_get_order_type(cp_header_id number) is
4348: select order_type_id
4349: from oe_order_headers_all
4350: where header_id = cp_header_id;
4351:
4352: cursor c_get_invoice_type(cp_order_header_id number) is
4353: select batch_source_id