Oracle Apps

  Users attached to Responsibilities and having Approval limits Null  select hou.name "Org name",        u.user_name "User Name",        u.description  "User Description",        u.start_date "User Start Date",        u.end_date "User End Date",        pe.full_name "Employee Name",    pe.person_id "Employee id",        pe.effective_start_date "Employee Start Date",        pe.effective_end_date "Employee End Date",        (SELECT name           FROM apps.per_all_positions pap          WHERE pap.position_id = pas.position_id) "Employee Position",          amount_limit "PR Approval Amount"   from apps.fnd_user u,        apps.fnd_user_resp_groups_direct furg,        apps.fnd_responsibility...

 Active project Managers Query SELECT DISTINCT hou.name org_name,        ppa.name project_name,        ppa.segment1 project_number,        ppa.project_type,    pe.full_name Project_Manager,    amount_limit Purchase_Requisition_approval,    pe.email_address,        ppa.start_date,        to_char(ppa.completion_date,'DD-MON-YYYY')completion_date ,        ppa.closed_date,        ppa.enabled_flag   FROM apps.pa_project_parties ppp,    apps.pa_projects_all ppa,    apps.pa_project_role_types pprt,    apps.per_all_people_f pe,    apps.pa_project_assignments pa,    apps.fnd_user u,        apps.hr_operating_units hou,   (SELECT paf.person_id,   paf.assignment_type,       pcr.amount_limit   ...

  Types of Banks in Oracle apps 1) Internal Bank 2) External Bank   Internal Bank   Internal Bank are the Oracle our Internal Banks or Business Unit & Organization Internals Banks which they use to Pay Customer Invoice and to do the receiving of the Customer Payments.   Important Tables of Internal Banks   select * from CE_BANK_ACCOUNTS  select * from CE_BANK_ACCT_USES_ALL select * from CE_BANKS_V select * from CE_BANK_ACCT_USES_ALL; select * from CE_BANK_BRANCHES_V   External Banks:-   External Banks are those Banks,  Which is related to Our or Organization & Business unit Customers and Suppliers. Both Customer & Suppliers are external Entities so Oracle has stored these Banking Information in different tables as compared to the Internal Banks.   Important External Bank Tables 1 Select * from iby_external_payers_all 2 Select * from iby_pmt_instr_uses_all 3 Select * from iby_ext_bank_accounts

Using PIVOT Sample Sql  SELECT         accounting,         research,         sales,         operations     FROM         (             SELECT                 dname             FROM                 dept         ) PIVOT (             MAX ( dname )             FOR dname             IN ( 'ACCOUNTING' AS accounting, 'RESEARCH' AS research, 'SALES' AS sales, 'OPERATIONS' AS operations )         );

Pass multiple values to a single parameter in PL/SQL CREATE or REPLACE PROCEDURE XX_SAMPLE_TEST(P_ITEM varchar2) is     i                      number;     l_length          number;     r                     number;     l_count          number;     l_item            varchar2(50); BEGIN     l_length := length(P_ITEM);     i := 1;     r := 1;     WHILE (i < l_length)     LOOP          l_count := (INSTR(P_ITEM,',',1,r)-i);         IF  l_count < 0 THEN              l_count := l_length;         END IF;         SELECT substr(...

Deleting the Sourcing Rule Assignments API DECLARE        l_return_status VARCHAR2(200);        l_msg_count  NUMBER;        l_msg_data VARCHAR2(2000);        l_assignment_set_rec mrp_src_assignment_pub.assignment_set_rec_type;        l_assignment_set_val_rec mrp_src_assignment_pub.assignment_set_val_rec_type;        l_assignment_tbl mrp_src_assignment_pub.assignment_tbl_type;        l_assignment_val_tbl mrp_src_assignment_pub.assignment_val_tbl_type;        o_assignment_set_rec mrp_src_assignment_pub.assignment_set_rec_type;        o_assignment_set_val_rec mrp_src_assignment_pub.assignment_set_val_rec_type;        o_assignment_tbl mrp_src_assignment_pub.assignment_tbl_type;        o_assignment_val_tbl mrp_src_assignment_pub.assignment_val_tbl_type; ...