Showing posts with label Queries. Show all posts
Showing posts with label Queries. Show all posts
Friday, August 7, 2015

Query to Derive Customer Number, Site Use ID from Customer Bank Account Number

›
SELECT hca.account_number, hcsu.site_use_id, hca.cust_account_id INTO l_custo...
Tuesday, June 9, 2015

Oracle Apps : Apply AP Invoice Hold using API

›
The hold codes can be extracted from query below. SELECT *   FROM ap_hold_codes  WHERE hold_type = 'INVOICE HOLD REASON'; Belo...
Thursday, June 4, 2015

Query to Find Attached Template Name from Template Code

›
SELECT template_code, file_name   FROM xdo_templates_b a, xdo_lobs b  WHERE     b.lob_code = a.template_code        AND b.xdo_file_type ...
Tuesday, May 26, 2015

Query to drill down from PO header to shipment

›
SELECT poll.*   FROM po_headers_all poh,        po_releases_all pora,        po_lines_all pla,        po_line_locations_all poll  WHE...
Thursday, May 21, 2015

How To Disable/End Date/ Delete Responsibilities of a User from Backend/API

›
Below is the query. Please not Responsibilities cannot be deleted in Oracle Apps from a User. It can only be Disabled or End Dated. BEG...
Tuesday, May 19, 2015

Query to Find Database Version in Oracle

›
select * from v$version; Output:
Wednesday, January 28, 2015

Query to find the parent request id recursively

›
SELECT request_id,   description FROM fnd_concurrent_requests WHERE NVL (request_type, 'X')        = 'M'   CONNECT BY PR...
Friday, October 17, 2014

Query to derive Qualifier Attribute and Context from Modifier Name

›
Query : SELECT    c.list_line_no "Modifier Line No",   b.name "Modifier Name",   b.description  "Modifier Desc...
Friday, September 5, 2014

Status Codes and Phase Codes of a Concurrent Request : Oracle EBS R12

›
Concurrent Request Status Codes :  SELECT LOOKUP_CODE, MEANING   FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'CP_STATUS_CODE'  ...
Friday, July 4, 2014

Query to find rejection Messages during AP Interface : Oracle R12

›
SELECT air.* FROM ap_interface_rejections air,      ap_invoice_lines_interface aili,      ap_invoices_interface aii WHERE aii.invoice_...
Tuesday, July 1, 2014

Example : How to Generate Code Combination ID's (CCID) from Backend in Oracle R12

›
DECLARE   l_code_combination_id       NUMBER;   l_boolean                   BOOLEAN;   l_segment_array             APPS.FND_FLEX_EXT.SEG...
Sunday, June 15, 2014

Query to find the orig system reference for a Customer/Party and other TCA entities

›
If the data was imported into the EBS system from ABC system and ABC's party id was used as the cross system , the below query can be u...
1 comment:

Important TCA lookups

›
Lookup for Customer Class code select lookup_type,lookup_code,meaning from ar_lookups where lookup_type in (select class_category from HZ...
Saturday, May 17, 2014

Accounting FlexFields of Bank Account in R12

›
alter session set current_schema=apps; SELECT cba.Bank_Account_Name,   cbbv.Bank_Name,   cbbv.Bank_Branch_Name,   cba.Bank_Account_Num...

Request Set of a Concurrent Program

›
Provide Concurrent Program name to the following query. It lists all the Request Sets which are created with the Concurrent Program given....

Programs in a Request Set

›
Provide the Request Set name to the following query. It lists all concurrent programs of this Request Set. SELECT USER_CONCURRENT_PROGRA...

Query to find ORG_ID attached to a responsibility

›
SELECT * --fpov.profile_option_value              FROM applsys.fnd_profile_option_values fpov                 , applsys.fnd_profile_optio...
1 comment:

TCA Parties Table Drill Down

›
SELECT * FROM hz_parties WHERE party_name = 'Saikam INTL' -- party_id = 39266,party_number(registry_id)= 1849,party_type = organiza...

Query to find strategies of a Customer Oracle R12 AR

›
Strategies of a Customer SELECT DISTINCT(ist.cust_account_id),   ist.status_code,   ist.strategy_id,   ist.strategy_template_id,   i...

Query to find responsibilities attached to a user in Oracle R12

›
SELECT * FROM FND_USER WHERE user_name LIKE 'DAVIDEVANS'; SELECT *   FROM FND_USER_RESP_GROUPS  WHERE user_id=1180; --user_id i...