APPS.ICX_REQ_ACCT2 dependencies on ICX_SHOPPING_CART_LINES

Line 40: from icx_shopping_cart_lines

36: and gl.CODE_COMBINATION_ID = acct_id;
37:
38: cursor get_cart_line_number(cartid number, cartline_id number) is
39: select cart_line_number
40: from icx_shopping_cart_lines
41: where cart_id = cartid
42: and cart_line_id = cartline_id;
43:
44:

Line 194: from icx_shopping_cart_lines

190: and nvl(org_id,-9999) = nvl(v_oo_id,-9999);
191:
192: cursor get_cart_line_number is
193: select cart_line_number
194: from icx_shopping_cart_lines
195: where cart_id = v_cart_id
196: and cart_line_id = v_cart_line_id;
197:
198: l_cart_line_number NUMBER := 0;

Line 419: from icx_shopping_cart_lines

415: l_cart_line_number NUMBER := 0;
416:
417: cursor get_cart_line_number is
418: select cart_line_number
419: from icx_shopping_cart_lines
420: where cart_id = v_cart_id
421: and cart_line_id = v_cart_line_id;
422:
423: /* New vars added to take care of Bind Vars ***/

Line 792: from icx_shopping_cart_lines

788: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
789:
790: cursor get_cart_line_number(cartid number,cartline_id number) is
791: select cart_line_number
792: from icx_shopping_cart_lines
793: where cart_id = cartid
794: and cart_line_id = cartline_id;
795:
796: l_cart_line_number NUMBER := 0;

Line 917: from icx_shopping_cart_lines

913: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
914:
915: cursor get_cart_line_number(cartid number,cartline_id number) is
916: select cart_line_number
917: from icx_shopping_cart_lines
918: where cart_id = cartid
919: and cart_line_id = cartline_id;
920:
921: l_cart_line_number NUMBER := 0;

Line 1026: icx_shopping_cart_lines iscl

1022: CURSOR item_expense_account is
1023: select msi.expense_account
1024: from mtl_system_items msi,
1025: icx_shopping_carts isc,
1026: icx_shopping_cart_lines iscl
1027: where msi.inventory_item_id(+) = iscl.item_id
1028: AND nvl(msi.ORGANIZATION_ID,
1029: nvl(isc.DESTINATION_ORGANIZATION_ID,
1030: iscl.DESTINATION_ORGANIZATION_ID)) =

Line 1047: from icx_shopping_cart_lines

1043: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1044:
1045: cursor get_cart_line_number is
1046: select cart_line_number
1047: from icx_shopping_cart_lines
1048: where cart_id = v_cart_id
1049: and cart_line_id = v_cart_line_id
1050: and nvl(org_id, -9999) = nvl(v_oo_id,-9999);
1051:

Line 1183: icx_shopping_cart_lines iscl

1179: CURSOR item_expense_account is
1180: select msi.expense_account
1181: from mtl_system_items msi,
1182: icx_shopping_carts isc,
1183: icx_shopping_cart_lines iscl
1184: where msi.inventory_item_id(+) = iscl.item_id
1185: AND nvl(msi.ORGANIZATION_ID,
1186: nvl(isc.DESTINATION_ORGANIZATION_ID,
1187: iscl.DESTINATION_ORGANIZATION_ID)) =

Line 1205: from icx_shopping_cart_lines

1201: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1202:
1203: cursor get_cart_line_number is
1204: select cart_line_number
1205: from icx_shopping_cart_lines
1206: where cart_id = v_cart_id
1207: and cart_line_id = v_cart_line_id;
1208:
1209: l_cart_line_number NUMBER := 0;

Line 1330: from icx_shopping_cart_lines

1326: and nvl(org_id,-9999) = nvl(oo_id,-9999);
1327:
1328: cursor get_cart_line_number(cartid number, cartline_id number) is
1329: select cart_line_number
1330: from icx_shopping_cart_lines
1331: where cart_id = cartid
1332: and cart_line_id = cartline_id;
1333:
1334: