[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
397: gl_sets_of_books sob,
398: fnd_currencies fc,
399: jtf_rs_salesreps rs,
400: ar_system_parameters sp,
401: zx_product_options zxpo
402: where sp.set_of_books_id = sob.set_of_books_id
403: and sob.currency_code = fc.currency_code
404: and nvl(sp.org_id,-99) = nvl(rs.org_id,-99)
405: and sp.org_id = nvl(p_org_id, sp.org_id)/* Bug 5051539 */
725: gl_sets_of_books sob,
726: fnd_currencies fc,
727: jtf_rs_salesreps rs,
728: ar_system_parameters sp,
729: zx_product_options zxpo
730: where sp.set_of_books_id = sob.set_of_books_id
731: and sob.currency_code = fc.currency_code
732: and nvl(sp.org_id,-99) = nvl(rs.org_id,-99)
733: and sp.org_id = nvl(p_org_id, sp.org_id) /* Bug 5051539 */
788: RAISE; --end of WHEN NO DATA FOUND
789: end;
790:
791: /* ---------------------------------------------------
792: Check if row exists in zx_product_options
793: --------------------------------------------------*/
794: /* No longer require to check ZX_PRODUCT_OPTIONS in R12 */
795:
796: END LOOP;
790:
791: /* ---------------------------------------------------
792: Check if row exists in zx_product_options
793: --------------------------------------------------*/
794: /* No longer require to check ZX_PRODUCT_OPTIONS in R12 */
795:
796: END LOOP;
797:
798: IF l_exp_flag ='N' THEN