DBA Data[Home] [Help]

APPS.RLM_VALIDATEDEMAND_SV dependencies on OE_SYS_PARAMETERS

Line 6079: AND oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG') IN ('Y', 'A'));

6075: WHERE related_cust_account_id = x_header_rec.customer_id
6076: AND ship_to_flag = 'Y'
6077: AND status = 'A'
6078: AND org_id = x_header_rec.org_id
6079: AND oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG') IN ('Y', 'A'));
6080: --
6081: IF (l_debug <> -1) THEN
6082: rlm_core_sv.dlog(C_DEBUG,'intrmd_ship_to_id ',
6083: x_lines_rec.intrmd_ship_to_id);

Line 6442: AND oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG', x_header_rec.org_id) IN ('Y', 'A')

6438: FROM HZ_CUST_ACCT_RELATE_ALL
6439: WHERE related_cust_account_id = x_header_rec.customer_id
6440: AND status='A'
6441: AND bill_to_flag = 'Y'
6442: AND oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG', x_header_rec.org_id) IN ('Y', 'A')
6443: AND org_id = x_header_rec.org_id
6444: );
6445: --
6446: IF (l_debug <> -1) THEN

Line 6834: AND oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG')

6830: WHERE related_cust_account_id = x_header_rec.customer_id
6831: AND ship_to_flag = 'Y'
6832: AND status = 'A'
6833: AND org_id = x_header_rec.org_id
6834: AND oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG')
6835: IN ('Y', 'A'));
6836: --
6837: IF (l_debug <> -1) THEN
6838: rlm_core_sv.dlog(C_DEBUG,'ship_to_address_id ',

Line 9591: v_parameter := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG',

9587: END IF;
9588: --
9589: -- Use Customer relationship only if the OM profile option is set.
9590: --
9591: v_parameter := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG',
9592: MO_GLOBAL.get_current_org_id);
9593: --
9594: IF (l_debug <> -1) THEN
9595: rlm_core_sv.dlog(C_DEBUG,'v_parameter',v_parameter);