[Home] [Help]
6036: WHERE related_cust_account_id = x_header_rec.customer_id
6037: AND ship_to_flag = 'Y'
6038: AND status = 'A'
6039: AND org_id = x_header_rec.org_id
6040: AND oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG') IN ('Y', 'A'))
6041: ORDER BY site_uses.status; --To query first Active and then Inactive records
6042:
6043: CURSOR c_IntrmdShipToID IS --Added cursor as part of Bugfix 8672453
6044: SELECT hcas.status, cust_account_id, hcsu.status,
6358: FROM HZ_CUST_ACCT_RELATE_ALL
6359: WHERE related_cust_account_id = x_header_rec.customer_id
6360: AND status='A'
6361: AND bill_to_flag = 'Y'
6362: AND oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG', x_header_rec.org_id) IN ('Y', 'A')
6363: AND org_id = x_header_rec.org_id)
6364: ORDER BY SITE_USE.status; --To query first Active and then Inactive records
6365:
6366: CURSOR c_BillToID_org_level IS --Added cursor as part of Bugfix 8672453
6817: WHERE related_cust_account_id = x_header_rec.customer_id
6818: AND ship_to_flag = 'Y'
6819: AND status = 'A'
6820: AND org_id = x_header_rec.org_id
6821: AND oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG')
6822: IN ('Y', 'A'))
6823: ORDER BY hcsu.status; --To query first Active and then Inactive records
6824:
6825: CURSOR c_ShipToID_header_ext IS --Added cursor as part of Bugfix 8672453
9663: END IF;
9664: --
9665: -- Use Customer relationship only if the OM profile option is set.
9666: --
9667: v_parameter := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG',
9668: MO_GLOBAL.get_current_org_id);
9669: --
9670: IF (l_debug <> -1) THEN
9671: rlm_core_sv.dlog(C_DEBUG,'v_parameter',v_parameter);