DBA Data[Home] [Help]

APPS.ICX_PO_REQ_ACCT2 dependencies on ICX_SHOPPING_CART_LINES

Line 472: from icx_shopping_cart_lines

468: l_cart_line_number NUMBER := 0;
469:
470: cursor get_cart_line_number is
471: select cart_line_number
472: from icx_shopping_cart_lines
473: where cart_id = v_cart_id
474: and cart_line_id = v_cart_line_id;
475:
476:

Line 1103: icx_shopping_cart_lines iscl

1099: CURSOR item_expense_account is
1100: select msi.expense_account
1101: from mtl_system_items msi,
1102: icx_shopping_carts isc,
1103: icx_shopping_cart_lines iscl
1104: where msi.inventory_item_id(+) = iscl.item_id
1105: AND nvl(msi.ORGANIZATION_ID,
1106: nvl(isc.DESTINATION_ORGANIZATION_ID,
1107: iscl.DESTINATION_ORGANIZATION_ID)) =

Line 1124: from icx_shopping_cart_lines

1120: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1121:
1122: cursor get_cart_line_number is
1123: select cart_line_number
1124: from icx_shopping_cart_lines
1125: where cart_id = v_cart_id
1126: and cart_line_id = v_cart_line_id
1127: and nvl(org_id, -9999) = nvl(v_oo_id,-9999);
1128:

Line 1411: from icx_shopping_cart_lines

1407: and nvl(org_id,-9999) = nvl(oo_id,-9999);
1408:
1409: cursor get_cart_line_number(cartid number, cartline_id number) is
1410: select cart_line_number
1411: from icx_shopping_cart_lines
1412: where cart_id = cartid
1413: and cart_line_id = cartline_id;
1414:
1415: