Oracle Apps SQL Query for Customer data

Oracle apps R12 AR SQL Query to get Customer Address details

SQL Query for Oracle Apps R12 – to get Customer Address details . Comment the Account Number condition to get it for all Customer Data SELECT          HCA.ACCOUNT_NUMBER          CUSTOMER_NUMBER,                 HP.PARTY_NAME               CUSTOMER_NAME,                 HPS.PARTY_SITE_NUMBER       CUST_SITE_NUMBER,                 HL.ADDRESS1                 ADDRESS_LINE1,                 HL.ADDRESS2                 ADDRESS_LINE2,                 HL.ADDRESS3                 ADDRESS_LINE3,                 HL.ADDRESS4                 ADDRESS_LINE4,                 HL.CITY                     CITY,                 HL.POSTAL_CODE              POSTAL_CODE,                 HL.STATE                    STATE, […]

Scroll to top
Copy Protected by Chetan's WP-Copyprotect.