[Home] [Help]
1538: SELECT 'X'
1539: FROM OKS_BILLING_PROFILES_B A,
1540: HZ_CUST_SITE_USES_ALL CS,
1541: HZ_PARTY_SITES PS,
1542: HZ_CUST_ACCT_SITES_ALL CA
1543: WHERE A.ID = HST.RENEWAL_BILLING_PROFILE_ID
1544: AND A.OWNED_PARTY_ID1 = HST.CUSTOMER_PARTY_ID
1545: AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID
1546: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID
1884: THEN 'N' ELSE 'Y' END) QAC_V
1885: ,(CASE WHEN COUNT(DISTINCT AP.ROWID) OVER (PARTITION BY HST.ROWID) <> 1
1886: THEN 'N' ELSE 'Y' END) AP_V
1887: FROM OKS_INT_HEADER_STG_TEMP HST
1888: ,HZ_CUST_ACCT_SITES_ALL QPS
1889: ,HZ_CUST_ACCOUNT_ROLES QTC
1890: ,HZ_CONTACT_POINTS QTP
1891: ,HZ_CONTACT_POINTS QTF
1892: ,HZ_CONTACT_POINTS QTE
2802: AND R.DIRECTIONAL_FLAG = 'F') SCN */
2803: ,HZ_CUST_SITE_USES_ALL BTSUI
2804: ,HZ_CUST_SITE_USES_ALL STSUI
2805: ,(SELECT CSU.ROWID ROW_ID, CSU.SITE_USE_ID, CSU.LOCATION, HT.HEADER_INTERFACE_ID
2806: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT
2807: WHERE CSU.SITE_USE_CODE = 'BILL_TO'
2808: AND CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
2809: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2810: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID
2809: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2810: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID
2811: AND CSU.ORG_ID = HT.OPERATING_UNIT_ID) BTSUN
2812: ,(SELECT CSU.ROWID ROW_ID, CSU.SITE_USE_ID, CSU.LOCATION, HT.HEADER_INTERFACE_ID
2813: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT
2814: WHERE CSU.SITE_USE_CODE = 'SHIP_TO'
2815: AND CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
2816: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2817: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID