APPS.IBW_OE_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 220: FROM aso_quote_headers_all

216: LOOP
217:
218: SELECT COUNT(order_id)
219: INTO l_rec_count
220: FROM aso_quote_headers_all
221: WHERE quote_header_id = SUBSTR(page_view.evnt_id,0,INSTR(page_view.evnt_id,',NOORDER')-1); --Changed by Sanjay. Changed NULL to NOORDER
222: IF l_rec_count > 0
223: THEN
224: UPDATE ibw_page_views_tmp tmp

Line 227: FROM aso_quote_headers_all

223: THEN
224: UPDATE ibw_page_views_tmp tmp
225: SET tmp.evnt_id =
226: (SELECT quote_header_id|| ','|| NVL(order_id,'NULL')
227: FROM aso_quote_headers_all
228: WHERE quote_header_id = SUBSTR(tmp.evnt_id,0,INSTR(tmp.evnt_id,',NOORDER')-1)) --Changed by Sanjay. Changed NULL to NOORDER
229: ,tmp.evnt_type=l_xchkout_code
230: ,tmp.process_flag = null
231: WHERE tmp.rec_id = page_view.rec_id;

Line 236: FROM aso_quote_headers_all

232: ELSE
233: UPDATE ibw_page_views_tmp tmp
234: SET tmp.evnt_id =
235: (SELECT quote_header_id
236: FROM aso_quote_headers_all
237: WHERE quote_header_id = SUBSTR(tmp.evnt_id,0,INSTR(tmp.evnt_id,',NOORDER')-1)) --Changed by Sanjay. Changed NULL to NOORDER
238: ,tmp.evnt_type=l_cart_code
239: ,tmp.process_flag = null
240: WHERE tmp.rec_id = page_view.rec_id;

Line 524: * To know whether the cart has been converted into order the select stmt on the aso_quote_headers_all is giving a string

520: /*
521: * Event validations and getting more information out of the published:
522: * For Express Check out: iStore will publish the cart id, we should get the order id if the cart has been converted.
523: * Otherwise the event will be cached in the page_views_tmp table to be picked up in the next run of this program.
524: * To know whether the cart has been converted into order the select stmt on the aso_quote_headers_all is giving a string
525: * like "cart_id,order_id" where order_id could be a known string like 'NOORDER'
526: *
527: * For Order Creation: iStore will publish cart id, we need to get the order id.
528: */

Line 537: FROM aso_quote_headers_all

533: || DECODE ( order_id
534: , NULL, 'NOORDER' --Changed by Sanjay. Changed from NULL to NOORDER
535: , TO_CHAR ( order_id )
536: )
537: FROM aso_quote_headers_all
538: WHERE quote_header_id =
539: SUBSTR ( pat.attribute21
540: , INSTR ( pat.attribute21
541: , '=' )

Line 545: FROM aso_quote_headers_all

541: , '=' )
542: + 1 ))
543: , '-1' )
544: , l_order_code, ( SELECT TO_CHAR ( order_id )
545: FROM aso_quote_headers_all
546: WHERE quote_header_id =
547: SUBSTR ( pat.attribute21
548: , INSTR ( pat.attribute21
549: , '=' )

Line 1019: FROM aso_quote_headers_all

1015: || DECODE ( order_id
1016: , NULL, 'NOORDER' --Changed by Sanjay. NULL to NORDER
1017: , TO_CHAR ( order_id )
1018: )
1019: FROM aso_quote_headers_all
1020: WHERE quote_header_id =
1021: SUBSTR ( pat.attribute21
1022: , INSTR ( pat.attribute21
1023: , '=' )

Line 1026: FROM aso_quote_headers_all

1022: , INSTR ( pat.attribute21
1023: , '=' )
1024: + 1 ))
1025: , l_order_code, ( SELECT order_id
1026: FROM aso_quote_headers_all
1027: WHERE quote_header_id =
1028: SUBSTR ( pat.attribute21
1029: , INSTR ( pat.attribute21
1030: , '=' )