APPS.ICX_REQ_COPY_REQ dependencies on ICX_SHOPPING_CART_LINES

Line 707: -- SELECT icx_shopping_cart_lines_s.NEXTVAL

703:
704: v_cart_line_number := v_cart_line_number + 1;
705:
706: --changed by alex for attachment
707: -- SELECT icx_shopping_cart_lines_s.NEXTVAL
708: -- INTO v_cart_line_id
709: -- FROM DUAL;
710: --new code:
711: SELECT PO_REQUISITION_LINES_S.NEXTVAL

Line 716: INSERT INTO icx_shopping_cart_lines (

712: INTO v_cart_line_id
713: FROM DUAL;
714:
715:
716: INSERT INTO icx_shopping_cart_lines (
717: cart_line_id,
718: cart_line_number,
719: last_update_date,
720: last_updated_by,

Line 871: -- This is required as the view of ICX_SHOPPING_CART_LINES_V has

867: AND rl.requisition_line_id = rd.requisition_line_id;
868:
869:
870: -- Update the distribution num column in distributions table.
871: -- This is required as the view of ICX_SHOPPING_CART_LINES_V has
872: -- join condition as DISTRIBUTION_NUM = 1.
873: -- The reqs from sources other than web reqs may not have populated
874: -- the distribuion number.
875:

Line 901: UPDATE icx_shopping_cart_lines b

897: END LOOP; /* FOR distribution */
898:
899: END LOOP; /* FOR prec ... */
900:
901: UPDATE icx_shopping_cart_lines b
902: SET item_number = ( SELECT a.concatenated_segments
903: FROM mtl_system_items_kfv a
904: WHERE a.inventory_item_id = b.item_id
905: AND a.organization_id = b.destination_organization_id