[Home] [Help]
75: instead of ra_salesreps view. Lookup retrieval from ar_lookups
76: replaced by calls to get_lookup function */
77:
78: /* Bug 4188835 - replaced numerous sp columns with some
79: from zx_product_options */
80:
81: /* 4923225 - made zx_product_options an outer join */
82:
83: /* 5051539 - Added org_id filter to only retrieve for org_id if passed */
77:
78: /* Bug 4188835 - replaced numerous sp columns with some
79: from zx_product_options */
80:
81: /* 4923225 - made zx_product_options an outer join */
82:
83: /* 5051539 - Added org_id filter to only retrieve for org_id if passed */
84:
85: select
403: gl_sets_of_books sob,
404: fnd_currencies fc,
405: jtf_rs_salesreps rs,
406: ar_system_parameters sp,
407: zx_product_options zxpo
408: where sp.set_of_books_id = sob.set_of_books_id
409: and sob.currency_code = fc.currency_code
410: and nvl(sp.org_id,-99) = nvl(rs.org_id,-99)
411: and sp.org_id = nvl(p_org_id, sp.org_id)/* Bug 5051539 */
737: gl_sets_of_books sob,
738: fnd_currencies fc,
739: jtf_rs_salesreps rs,
740: ar_system_parameters sp,
741: zx_product_options zxpo
742: where sp.set_of_books_id = sob.set_of_books_id
743: and sob.currency_code = fc.currency_code
744: and nvl(sp.org_id,-99) = nvl(rs.org_id,-99)
745: and sp.org_id = nvl(p_org_id, sp.org_id) /* Bug 5051539 */
800: RAISE; --end of WHEN NO DATA FOUND
801: end;
802:
803: /* ---------------------------------------------------
804: Check if row exists in zx_product_options
805: --------------------------------------------------*/
806: /* No longer require to check ZX_PRODUCT_OPTIONS in R12 */
807:
808: END LOOP;
802:
803: /* ---------------------------------------------------
804: Check if row exists in zx_product_options
805: --------------------------------------------------*/
806: /* No longer require to check ZX_PRODUCT_OPTIONS in R12 */
807:
808: END LOOP;
809:
810: IF l_exp_flag ='N' THEN