SELECT fu.user_name CP_RUNBY , to_char(fcr.request_date,'DD-Mon-YYYY') CP_RUNDATEFROM fnd_concurrent_requests fcr , fnd_user fuWHERE fcr.requested_by =fu.user_id AND fcr.request_id = fnd ...
SELECT DISTINCT PAPF.FULL_NAME APPROVED_BY , AIAH.APPROVER_COMMENTS , TO_CHAR(AIAH.LAST_UPDATE_DATE,'DD-MON-YYYY') APPROVAL_DATE , APPROVAL_HISTORY_IDFROM AP_INV_APRVL_HIST_ALL AIAH , FND_USER FUS , PER_ALL_PEOPLE_F PAPFWHERE INVOICE_ID ...
Select distinct AIA.INVOICE_NUM , AIA.INVOICE_DATE , JTD.TAX_CATEGORY_NAME GST_TAX_CAT , JTD.LINE_AMTfrom APPS.JAI_TAX_DET_FCT_LINES_V JTD , AP_INVOICES_ALL AIAwhere AIA.INVOICE_ID =:P_INVOICE_ID and JTD.TRX_NUMBER ...
SELECT JAW.REGIME_CODE , JAW.ACTUAL_SECTION_CODE , JAI.TDS_TAX_RATE , JAW.TAX_AMOUNT , JAW.PROCESS_MESSAGE , ( SELECT CONCATENATED_SEGMENTS FROM ...
SELECT DISTINCT hold_date , hold_lookup_code , hold_reasonFROM ap_holds_allWHERE invoice_id = :P_INVOICE_ID and STATUS_FLAG=' ...
APAP Base TablesccidinvoicePOprojects
AP Invoice, Invoice Lines ,distributions and Projects details in oracle Apps
posted on , by Adarsh
SELECT DISTINCT AILA.LINE_TYPE_LOOKUP_CODE LINE_TYPE , AILA.DESCRIPTION INV_LINE_DESCRIPTION , ( SELECT DISTINCT SEGMENT1 FROM PO_HEADERS_ALL PHA ...
AP Base TablesApproverinvoiceSupplierTDS
AP Invoice Details query with TDS and Supplier information
posted on , by Adarsh
SELECT DISTINCT TO_CHAR(SYSDATE,'DD-MON-YYYY') RUNDATE, AIA.INVOICE_ID, AIA.INVOICE_NUM, ASU.VENDOR_NAME, ASSA.VENDOR_SITE_CODE, ASU.SEGMENT1 SUPPLIER_NUM, AIA.INVOICE_ID VOUCHER, AIA.ATTRIBUTE5 INV_CATEGORY, ...
TCA Sr. No. Detail API Name Module 1 Create Customer Account HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT TCA 2 Create a Customer Account Relationship API HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCT_RELATE TCA 3 API to update a Customer Account Relationship TCA R12 HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCT_RELATE ...
