DBA Data[Home] [Help]

APPS.ICX_LOAD_REQ_INTERFACE dependencies on ICX_SHOPPING_CART_LINES

Line 12: from icx_shopping_cart_lines

8: l_trans_id number;
9:
10: cursor get_cart_line_id(l_cart_id number,l_org_id number) is
11: select cart_line_id
12: from icx_shopping_cart_lines
13: where cart_id = l_cart_id
14: and nvl(org_id,-9999) = nvl(l_org_id,-9999);
15:
16: Begin

Line 185: icx_shopping_cart_lines ici,

181: isc.cart_id,
182: ici.cart_line_id,
183: rtrim(isc.RESERVED_PO_NUM, ' ')
184: from icx_shopping_carts isc,
185: icx_shopping_cart_lines ici,
186: mtl_system_items msi,
187: po_headers poh,
188: hr_employees_current_v hrev,
189: FND_USER fwu

Line 342: icx_shopping_cart_lines ici,

338: icd.ALLOCATION_TYPE,
339: icd.ALLOCATION_VALUE,
340: icd.DISTRIBUTION_NUM
341: from icx_shopping_carts isc,
342: icx_shopping_cart_lines ici,
343: icx_cart_line_distributions icd
344: where isc.saved_flag = '0'
345: and isc.cart_id = ici.cart_id
346: and ici.cart_id = icd.cart_id