/*NEW PUBLIC API - INV_ABC_ASSIGNMENTS_PUB .CREATE_ABC_ASSIGNMENTS IS ADDED TO INSERT/UPDATE ABC ASSIGNMENTSIF THE ITEM ALREADY EXISTS IT WILL BE UPDATED/ASSIGNED TO THE NEW CLASS, ELSE WILL BE ADDED TO THE CLASS PASSED AS PARAMETER.*//* public api PLS file INVPAASS.pls ,INVPAASB.pls */ -- organization V1( master organization, M1 (child org )-- created item(s) ABC_API_1, ABC_API_2, ABC_API_3-- This data is from the table MTL_SYSTEM_ITEMS_B--SEGMENT1 ...
List of Receipts API in Oracle ReceivablesBelow is the list of some of the Receipt API’s in Oracle Receivables. Receipt APIs provide an extension to existing functionality for creating and manipulating receipts through standard AR Receipts forms and lockboxes.AR_RECEIPT_API_PUB is the main package that has several procedures to perform different actions.1] AR_RECEIPT_API_PUB.CREATE_CASHUse this procedure to create a single cash receipt for payment received in the form of a check or cash.2] ...
CollectionCollection is an Ordered group of elements, all of the same type.Attributes of Collection1. FIRST2. LAST3. COUNT4. DELETE5. EXTAND6. TRIM7. NEXT8. EXIST9. PRIOR10. LIMITTypes of Collection1. Varray2. Nested Table3. PL/SQL Table or Associate ArrayVarray:-Varray stands of variable size array.Varray can be stored in the column of table.Syntax of Varray:- Type type_name is VARRAY(length) of data_type;Examples of ...
Operating_unitsOrg_idorganization_id
Difference between Org_id ,organization_id and operating_unit in Oracle Apps
posted on , by Adarsh
Let us say you are having Inventory Store.You have Inventory Stores in two different countries like India and USAYou have installed Oracle Apps single instance and entered all the suppliers information, customers data, tax rules etc.And your business requirement is like this, all the rules and the data corresponding to indian store shouldn't be applicable/available to American store and vice versa.So to meet the above requirements you will define two operating units one for ...
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 ...
