Required Tools vOracle Apex (Version 5) Step 1 Create Tree Region Sample code: SELECT CASE WHEN CONNECT_BY_ISLEAF = 1 THEN 0 WHEN LEVEL = 1 THEN 1 ELSE –1 END AS status, LEVEL, Ename AS title, NULL AS icon,…
Read MoreDECLARE CURSOR User_end is select user_name from fnd_user where user_name in (SELECT user_name FROM irm_empl_issue …
Read MoreSELECT fp.period_name, adt.asset_number, adt.tag_number, bks.book_type_code, ltrim(rtrim(cat.segment1)) ||’-‘|| ltrim(rtrim(cat.segment2)) ||’-‘|| ltrim(rtrim(cat.segment3)) category, bks.date_placed_in_service, bks.original_cost, adt.description, adt.context subject_to_property_tax, adt.attribute1 property_tax_code, dn.deprn_reserve, nvl(bks.original_cost,0) – nvl(dn.deprn_reserve,0) net_book_value, dn.ytd_deprn, (select dhcc.segment1||’.’||dhcc.segment2||’.’||dhcc.segment3||’.’||dhcc.segment4||’.’||dhcc.segment5||’.’||dhcc.segment6||’.’||dhcc.segment7||’.’||dhcc.segment8||’.’||dhcc.segment9 from gl_code_combinations dhcc,fa_distribution_history…
Read Moreselect USER_CONCURRENT_PROGRAM_NAME,REQUEST_DATE,CNTPERDAY,week_no, case when week_no=1 then sum(CNTPERDAY) OVER (PARTITION BY USER_CONCURRENT_PROGRAM_NAME,week_no) else 0 end week_no_1, case when week_no=2 then sum(CNTPERDAY) OVER (PARTITION BY USER_CONCURRENT_PROGRAM_NAME,week_no) else 0 end week_no_2 ,case when…
Read MoreQuery to Fetch Leases which are expired but not terminated. SELECT GCC.segment4 SOL_ID ,PLA.lease_id Lease_number ,PLDA.attribute7 Agreement_no ,PAA.address_line1||’,’||PAA.address_line2||’,’||PAA.address_line3||’,’||PAA.address_line4||’,’||PAA.city||’,’||PAA.state…
Read MoreHRMS API :Create Position Hierarchy by Using APIs (hr_pos_hierarchy_ele_api.create_pos_hierarchy_ele) Hierarchy Name Checking query =========================== select * from per_position_structures where name=’Sample Hierarchy’ Parent Position Name Checking Query =================================== select *…
Read MoreOracle API Script for SHIP CONFIRMATION Using (WSH_DELIVERIES_PUB.Delivery_Action) —Ship Confirm Delivery using WSH_DELIVERIES_PUB.Delivery_Action—- Declare –Standard Parameters. p_api_version NUMBER; …
Read MoreOracle API Script for Pick Release for Sales order( wsh_deliveries_pub.delivery_action) —sample script for pick release— Declare x_return_status VARCHAR2 (2); x_msg_count …
Read MoreOE_ORDER_PUB.PROCESS_ORDER ( Sample Script Create and Book for Sales Order ) Declare l_count NUMBER; l_api_version_number NUMBER := 1; l_return_status VARCHAR2 (2000); l_msg_count NUMBER; l_msg_data VARCHAR2 (2000); l_msg_index NUMBER; API_ERROR EXCEPTION;…
Read MoreSELECT prh.segment1 ir_number, prh.creation_date ir_date, ppf.full_name requestor, hl.location_code, ood.organization_code destination_org_code, ood.organization_name destination_org_name, …
Read More