[Home] [Help]
1568: SELECT 'X'
1569: FROM OKS_BILLING_PROFILES_B A,
1570: HZ_CUST_SITE_USES_ALL CS,
1571: HZ_PARTY_SITES PS,
1572: HZ_CUST_ACCT_SITES_ALL CA
1573: WHERE A.ID = HST.RENEWAL_BILLING_PROFILE_ID
1574: AND A.OWNED_PARTY_ID1 = HST.CUSTOMER_PARTY_ID
1575: AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID
1576: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID
1914: THEN 'N' ELSE 'Y' END) QAC_V
1915: ,(CASE WHEN COUNT(DISTINCT AP.ROWID) OVER (PARTITION BY HST.ROWID) <> 1
1916: THEN 'N' ELSE 'Y' END) AP_V
1917: FROM OKS_INT_HEADER_STG_TEMP HST
1918: ,HZ_CUST_ACCT_SITES_ALL QPS
1919: ,HZ_CUST_ACCOUNT_ROLES QTC
1920: ,HZ_CONTACT_POINTS QTP
1921: ,HZ_CONTACT_POINTS QTF
1922: ,HZ_CONTACT_POINTS QTE
2850: AND R.DIRECTIONAL_FLAG = 'F') SCN */
2851: ,HZ_CUST_SITE_USES_ALL BTSUI
2852: ,HZ_CUST_SITE_USES_ALL STSUI
2853: ,(SELECT CSU.ROWID ROW_ID, CSU.SITE_USE_ID, CSU.LOCATION, HT.HEADER_INTERFACE_ID
2854: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT
2855: WHERE CSU.SITE_USE_CODE = 'BILL_TO'
2856: AND CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
2857: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2858: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID
2857: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2858: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID
2859: AND CSU.ORG_ID = HT.OPERATING_UNIT_ID) BTSUN
2860: ,(SELECT CSU.ROWID ROW_ID, CSU.SITE_USE_ID, CSU.LOCATION, HT.HEADER_INTERFACE_ID
2861: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT
2862: WHERE CSU.SITE_USE_CODE = 'SHIP_TO'
2863: AND CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
2864: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2865: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID