APPS.JAI_AR_IMPORT_POPU_PKG dependencies on OE_ORDER_LINES_ALL

Line 116: oe_order_lines_all

112: CURSOR c_ato_order IS
113: SELECT
114: 1
115: FROM
116: oe_order_lines_all
117: WHERE
118: item_type_code IN ('CONFIG', 'MODEL', 'OPTION', 'CLASS')
119: AND line_id = (SELECT ato_line_id
120: FROM oe_order_lines_all

Line 120: FROM oe_order_lines_all

116: oe_order_lines_all
117: WHERE
118: item_type_code IN ('CONFIG', 'MODEL', 'OPTION', 'CLASS')
119: AND line_id = (SELECT ato_line_id
120: FROM oe_order_lines_all
121: WHERE line_id = v_interface_line_attribute6 );
122:
123: CURSOR c_cust_trx_tax_line_amt IS
124: SELECT nvl(SUM(a.tax_amount),0)

Line 137: FROM oe_order_lines_all oel2

133: FROM
134: JAI_OM_WSH_LINES_ALL
135: WHERE
136: order_line_id IN (SELECT line_id
137: FROM oe_order_lines_all oel2
138: WHERE oel2.item_type_code = 'CONFIG'
139: AND oel2.header_id = (
140: SELECT header_id
141: FROM oe_order_lines_all oel

Line 141: FROM oe_order_lines_all oel

137: FROM oe_order_lines_all oel2
138: WHERE oel2.item_type_code = 'CONFIG'
139: AND oel2.header_id = (
140: SELECT header_id
141: FROM oe_order_lines_all oel
142: WHERE oel.line_id = v_interface_line_attribute6)
143: AND oel2.ato_line_id = (SELECT ato_line_id
144: FROM oe_order_lines_all oel1
145: WHERE oel1.line_id = v_interface_line_attribute6))

Line 144: FROM oe_order_lines_all oel1

140: SELECT header_id
141: FROM oe_order_lines_all oel
142: WHERE oel.line_id = v_interface_line_attribute6)
143: AND oel2.ato_line_id = (SELECT ato_line_id
144: FROM oe_order_lines_all oel1
145: WHERE oel1.line_id = v_interface_line_attribute6))
146: AND organization_id is not null
147: AND location_id is not null
148: AND rownum = 1 ;

Line 1217: from oe_order_lines_all

1213: is
1214:
1215: cursor c_item_type is
1216: select item_type_code
1217: from oe_order_lines_all
1218: where line_id = v_interface_line_attribute6;
1219:
1220: Cursor c_om_taxes(v_so_config_line_id Number) is
1221: select *

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

1221: select *
1222: from JAI_OM_OE_SO_TAXES
1223: where line_id = v_so_config_line_id;
1224:
1225: Cursor c_get_config_line_id(v_ato_line_id Varchar2, cp_item_code oe_order_lines_all.item_type_code%type) is
1226: Select line_id
1227: from oe_order_lines_all
1228: where ato_line_id = v_ato_line_id
1229: and item_type_code = cp_item_code;

Line 1227: from oe_order_lines_all

1223: where line_id = v_so_config_line_id;
1224:
1225: Cursor c_get_config_line_id(v_ato_line_id Varchar2, cp_item_code oe_order_lines_all.item_type_code%type) is
1226: Select line_id
1227: from oe_order_lines_all
1228: where ato_line_id = v_ato_line_id
1229: and item_type_code = cp_item_code;
1230:
1231: CURSOR c_get_om_lines(v_ato_line_id Varchar2) is

Line 1258: v_item_type oe_order_lines_all.item_type_code%type;

1254: v_tax_amount Number; --File.Sql.35 Cbabu :=0;
1255:
1256: ln_legal_entity_id NUMBER ;
1257: ln_hdr_exist_chk number;
1258: v_item_type oe_order_lines_all.item_type_code%type;
1259: l_api_name CONSTANT VARCHAR2(30) := 'Process_Taxes_for_ATO_Order()';
1260: BEGIN
1261:
1262: pv_return_code := jai_constants.successful ;

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

1298: (nvl(v_ont_source_code,'ORDER ENTRY') <> nvl(ltrim(rtrim(pr_new.interface_line_context)),'$$$')
1299: )
1300: then
1301: -- using the following cursor , we get the line_id
1302: -- of the 'config' item in oe_order_lines_all
1303: Open c_get_config_line_id(v_interface_line_attribute6, 'CONFIG');
1304: Fetch c_get_config_line_id into v_config_line_id;
1305: Close c_get_config_line_id;
1306:

Line 4853: FROM oe_order_lines_all

4849: SELECT organization_id, location_id
4850: FROM JAI_OM_WSH_LINES_ALL
4851: WHERE order_line_id IN
4852: (SELECT reference_line_id
4853: FROM oe_order_lines_all
4854: WHERE line_id = v_interface_line_attribute7
4855: );
4856:
4857:

Line 4957: FROM OE_ORDER_LINES_ALL

4953:
4954: CURSOR check_reference_existed
4955: IS
4956: SELECT 1
4957: FROM OE_ORDER_LINES_ALL
4958: WHERE LINE_ID = v_interface_line_attribute7
4959: AND reference_line_id = v_interface_line_attribute7;
4960:
4961: