APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on OE_ORDER_LINES_ALL

Line 799: oe_order_lines_all

795: CURSOR c_ato_order IS
796: SELECT
797: 1
798: FROM
799: oe_order_lines_all
800: WHERE
801: item_type_code IN ('CONFIG', 'MODEL', 'OPTION', 'CLASS')
802: AND line_id = (SELECT ato_line_id
803: FROM oe_order_lines_all

Line 803: FROM oe_order_lines_all

799: oe_order_lines_all
800: WHERE
801: item_type_code IN ('CONFIG', 'MODEL', 'OPTION', 'CLASS')
802: AND line_id = (SELECT ato_line_id
803: FROM oe_order_lines_all
804: WHERE line_id = v_interface_line_attribute6 );
805:
806: /* Retrieve Org + Loc from ja_in_so_picking_lines from the Config (Start) Item */
807: CURSOR c_ato_hdr_info IS

Line 814: FROM oe_order_lines_all oel2

810: FROM
811: JAI_OM_WSH_LINES_ALL
812: WHERE
813: order_line_id IN (SELECT line_id
814: FROM oe_order_lines_all oel2
815: WHERE oel2.item_type_code = 'CONFIG'
816: AND oel2.header_id = (
817: SELECT header_id
818: FROM oe_order_lines_all oel

Line 818: FROM oe_order_lines_all oel

814: FROM oe_order_lines_all oel2
815: WHERE oel2.item_type_code = 'CONFIG'
816: AND oel2.header_id = (
817: SELECT header_id
818: FROM oe_order_lines_all oel
819: WHERE oel.line_id = v_interface_line_attribute6)
820: AND oel2.ato_line_id = (SELECT ato_line_id
821: FROM oe_order_lines_all oel1
822: WHERE oel1.line_id = v_interface_line_attribute6))

Line 821: FROM oe_order_lines_all oel1

817: SELECT header_id
818: FROM oe_order_lines_all oel
819: WHERE oel.line_id = v_interface_line_attribute6)
820: AND oel2.ato_line_id = (SELECT ato_line_id
821: FROM oe_order_lines_all oel1
822: WHERE oel1.line_id = v_interface_line_attribute6))
823: AND organization_id is not null
824: AND location_id is not null
825: AND rownum = 1 ;

Line 1356: v_item_type oe_order_lines_all.item_type_code%type;

1352:
1353: -- Added an internal procedure for processing ATO Orders Bug # 2806274 - Sriram
1354:
1355: v_so_line_id Number;
1356: v_item_type oe_order_lines_all.item_type_code%type;
1357: v_ato_line_id Varchar2(30);
1358: v_config_line_id Number;
1359: v_ex_inv_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%type;
1360: v_pmt_reg JAI_OM_WSH_LINES_ALL.register%type;

Line 1441: from oe_order_lines_all

1437: Procedure Process_Taxes_for_ATO_Order is
1438:
1439: cursor c_item_type is
1440: select item_type_code
1441: from oe_order_lines_all
1442: where line_id = v_interface_line_attribute6;
1443:
1444: Cursor c_om_taxes(v_so_config_line_id Number) is
1445: select *

Line 1449: Cursor c_get_config_line_id(v_ato_line_id Varchar2, cp_item_code oe_order_lines_all.item_type_code%type) is

1445: select *
1446: from JAI_OM_OE_SO_TAXES
1447: where line_id = v_so_config_line_id;
1448:
1449: Cursor c_get_config_line_id(v_ato_line_id Varchar2, cp_item_code oe_order_lines_all.item_type_code%type) is
1450: Select line_id
1451: from oe_order_lines_all
1452: where ato_line_id = v_ato_line_id
1453: and item_type_code = cp_item_code; /*'CONFIG'; Ramananda for removal of SQL LITERALs */

Line 1451: from oe_order_lines_all

1447: where line_id = v_so_config_line_id;
1448:
1449: Cursor c_get_config_line_id(v_ato_line_id Varchar2, cp_item_code oe_order_lines_all.item_type_code%type) is
1450: Select line_id
1451: from oe_order_lines_all
1452: where ato_line_id = v_ato_line_id
1453: and item_type_code = cp_item_code; /*'CONFIG'; Ramananda for removal of SQL LITERALs */
1454:
1455: CURSOR c_get_om_lines(v_ato_line_id Varchar2) is

Line 1505: -- of the 'config' item in oe_order_lines_all

1501: (nvl(v_ont_source_code,'ORDER ENTRY') <> nvl(ltrim(rtrim(pr_new.interface_line_context)),'$$$') -- added by sriram - bug# 3607101
1502: )
1503: then
1504: -- using the following cursor , we get the line_id
1505: -- of the 'config' item in oe_order_lines_all
1506: Open c_get_config_line_id(v_interface_line_attribute6, 'CONFIG'); /* Modified by Ramananda for removal of SQL LITERALs */
1507: Fetch c_get_config_line_id into v_config_line_id;
1508: Close c_get_config_line_id;
1509:

Line 4571: FROM oe_order_lines_all

4567: SELECT organization_id, location_id
4568: FROM JAI_OM_WSH_LINES_ALL
4569: WHERE order_line_id IN
4570: (SELECT reference_line_id
4571: FROM oe_order_lines_all
4572: WHERE line_id = v_interface_line_attribute7 -- Removed to_char from to_char(line_id) for bug#5641896 by JMEENA
4573: );
4574:
4575: -- following cursor added by sriram -- bug # 2755890 to pick up the