APPS.ICX_POR_EXT_ITEM dependencies on GL_SETS_OF_BOOKS

Line 5501: -- Get to_currency from GL_SETS_OF_BOOKS, i.e. the functional currency

5497: return( rate );
5498:
5499: EXCEPTION
5500: when GL_CURRENCY_API.NO_RATE then
5501: -- Get to_currency from GL_SETS_OF_BOOKS, i.e. the functional currency
5502: SELECT currency_code
5503: INTO l_to_currency
5504: FROM GL_SETS_OF_BOOKS
5505: WHERE set_of_books_id = x_set_of_books_id;

Line 5504: FROM GL_SETS_OF_BOOKS

5500: when GL_CURRENCY_API.NO_RATE then
5501: -- Get to_currency from GL_SETS_OF_BOOKS, i.e. the functional currency
5502: SELECT currency_code
5503: INTO l_to_currency
5504: FROM GL_SETS_OF_BOOKS
5505: WHERE set_of_books_id = x_set_of_books_id;
5506:
5507: -- Bug#3352834
5508: SELECT USER_CONVERSION_TYPE

Line 5738: 'igl_sets_of_books gsb, '||

5734: 'ipo_lines_all pl, '||
5735: 'imtl_system_items_kfv mi, '||
5736: 'ipo_vendors icx_pv, '||
5737: 'ipo_vendor_sites_all pvs, '||
5738: 'igl_sets_of_books gsb, '||
5739: 'ifinancials_system_params_all fsp, '||
5740: --FPJ FPSL Extractor Changes
5741: 'ipo_line_types_b pltb, ';
5742: ELSE

Line 5751: 'gl_sets_of_books gsb, '||

5747: 'po_lines_all pl, '||
5748: 'mtl_system_items_kfv mi, '||
5749: 'po_vendors icx_pv, '||
5750: 'po_vendor_sites_all pvs, '||
5751: 'gl_sets_of_books gsb, '||
5752: 'financials_system_params_all fsp, '||
5753: --FPJ FPSL Extractor Changes
5754: 'po_line_types_b pltb, ';
5755: END IF;

Line 5972: 'igl_sets_of_books gsb, '||

5968: 'imtl_system_items_kfv mi, '||
5969: 'ipo_vendors icx_pv, '||
5970: 'ipo_vendor_sites_all pvs, '||
5971: 'ifinancials_system_params_all fsp, '||
5972: 'igl_sets_of_books gsb, '||
5973: '';
5974: -- Bug # 3865316
5975: -- Check for multiOrgFlag - gMultiOrgFlag
5976: IF gMultiOrgFlag = 'Y' THEN

Line 5997: 'gl_sets_of_books gsb, '||

5993: 'mtl_system_items_kfv mi, '||
5994: 'po_vendors icx_pv, '||
5995: 'po_vendor_sites_all pvs, '||
5996: 'financials_system_params_all fsp, '||
5997: 'gl_sets_of_books gsb, '||
5998: '';
5999: -- Bug # 3865316
6000: -- Check for multiOrgFlag - gMultiOrgFlag
6001: IF gMultiOrgFlag = 'Y' THEN

Line 6173: 'igl_sets_of_books gsb, '||

6169: 'imtl_system_items_tl mitl, '||
6170: 'imtl_item_categories mic, '||
6171: 'ipo_vendors icx_pv, '||
6172: 'ipo_vendor_sites_all pvs, '||
6173: 'igl_sets_of_books gsb, '||
6174: 'ifinancials_system_params_all fsp ';
6175: ELSE
6176: xViewStr2 := xViewStr2 ||
6177: 'po_approved_supplier_list pasl, '||

Line 6183: 'gl_sets_of_books gsb, '||

6179: 'mtl_system_items_tl mitl, '||
6180: 'mtl_item_categories mic, '||
6181: 'po_vendors icx_pv, '||
6182: 'po_vendor_sites_all pvs, '||
6183: 'gl_sets_of_books gsb, '||
6184: 'financials_system_params_all fsp ';
6185: END IF;
6186: xViewStr2 := xViewStr2 ||
6187: -- Bug#3213218/3163334 : pcreddy - Check for the load flag to be 'Y'.

Line 6285: 'igl_sets_of_books gsb, '||

6281: xViewStr2 := xViewStr2 ||
6282: 'imtl_system_items_kfv mi, '||
6283: 'imtl_categories_kfv mc, '||
6284: 'imtl_item_categories mic, '||
6285: 'igl_sets_of_books gsb, '||
6286: 'ifinancials_system_params_all fsp, ';
6287: ELSE
6288: xViewStr2 := xViewStr2 ||
6289: 'mtl_system_items_kfv mi, '||

Line 6292: 'gl_sets_of_books gsb, '||

6288: xViewStr2 := xViewStr2 ||
6289: 'mtl_system_items_kfv mi, '||
6290: 'mtl_categories_kfv mc, '||
6291: 'mtl_item_categories mic, '||
6292: 'gl_sets_of_books gsb, '||
6293: 'financials_system_params_all fsp, ';
6294: END IF;
6295: xViewStr2 := xViewStr2 ||
6296: 'mtl_units_of_measure_tl muom, '||

Line 6568: 'igl_sets_of_books gsb, '||

6564: 'ipo_ga_org_assignments t, '||
6565: 'ipo_vendor_sites_all pvs, '||
6566: 'imtl_system_items_kfv mi, '||
6567: 'imtl_system_items_kfv mi2, '|| -- Centralized Proc Impacts Enhancement
6568: 'igl_sets_of_books gsb, '||
6569: 'ifinancials_system_params_all fsp, '||
6570: 'ifinancials_system_params_all fsp2, '|| -- Centralized Proc Impacts Enhancement
6571: 'ipo_system_parameters_all icx_psp, ';
6572: ELSE

Line 6578: 'gl_sets_of_books gsb, '||

6574: 'po_ga_org_assignments t, '||
6575: 'po_vendor_sites_all pvs, '||
6576: 'mtl_system_items_kfv mi, '||
6577: 'mtl_system_items_kfv mi2, '|| -- Centralized Proc Impacts Enhancement
6578: 'gl_sets_of_books gsb, '||
6579: 'financials_system_params_all fsp, '||
6580: 'financials_system_params_all fsp2, '|| -- Centralized Proc Impacts Enhancement
6581: 'po_system_parameters_all icx_psp, ';
6582: END IF;