Oracle apps AR Receipt status

In Oracle Apps , Receipts could have the below given status during the transaction phase. APPROVED:  The status ‘APPROVED’ indicates that the receipt has been approved for automatic receipt creation. This status is only valid for automatic receipts. CONFIRMED: The status ‘CONFIRMED’ indicates that the customer has approved the application of this receipt and their […]

Read More

Oracle apps R12 AR SQL Query to get Customer Address details

Hi All, Please find belwo the 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, […]

Read More