Oracle Apps Service Contracts Queries
Oracle Apps Service Contracts Queries. I need to find which table has billing date for the contract and also how to find if a contract is ready to be invoiced. I am giving here top 30 useful oracle apps queries for dba.
Select the respective enabled check box to enable each qualifier. Clear this check box to credit the customer immediately. Select a discussion category from the picklist.
How To Query The Workflow Tables For Service Contract Workflows (Doc Id 846440.1) Last Updated On February 02, 2022.
To open the contract, select the contract line and click open. In 11i, use okc_k_headers_b instead of okc_k_headers_all_b. The application displays the list of qualifiers available for use in oracle service contracts:
The Query Will Ask For The Serial Number As Input.
For a complete list query the seeded quick menu for customer support csx_customer_support_qm. Oracle allows us to create the following types of service contracts: I have built the query below, but it doesn't seem to work:
The In Contracts Service Tables In Oracle Apps.
This note gives a variety of queries which can be used to find the required data for a particular contract. Oracle service contracts integrates with oracle advanced pricing to determine the contractual prices to be applied to a service. Select * in okc_k_headers_all_b, where contract_number such as :p_contract_number;
The Purpose Of The Seeded Qa Checks, With A Few Exceptions, Are Basically Limited To Verifying That Data In A Contract Is Entered So That The Contract Module's Standard Functionality Will Work Correctly.
In the body, insert detailed information, including oracle product and version. Login to us service contract manager. I am new to service to contracts and trying to come up with a query to find all contracts that are ready to be created as invoice but didn't get transferred to ra_interface_lines_all table.
I Need To Find Which Table Has Billing Date For The Contract And Also How To Find If A Contract Is Ready To Be Invoiced.
Oracle crm service contracts queries invoice customer. Navigate to the oracle service contracts folder in the territory manager navigator and create your territories. The service contracts authoring window appears.
Post a Comment for "Oracle Apps Service Contracts Queries"