Description: This query fetches the detailed information related to those assets which are added newly for a particular period. Script to New Asset Addition SELECT FAL.segment1 SOL_ID ,FFV.description BRANCH_NAME ,FAA.tag_number …
Read MoreDescription: When you define a concurrent program, you can list those programs you want it to be incompatible with. You can also list the program as inconsistent with itself, which…
Read MoreDescription: This query fetches those leases which are going to expire within 15,30,60,90,180 days, respectively, based on the parameter. SELECT GCC.segment4 SOL_ID ,gl_flexfields_pkg.get_description_SQL(GCC.chart_of_accounts_id ,4,GCC.segment4) BRANCH_NAME ,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 MoreDescription: The Hierarchy Diagrammer, included with Oracle HRMS, enables you to create your position hierarchies graphically, and make intuitive drag-and-drop changes to them. HRMS API :Create Position Hierarchy by Using…
Read MoreDescription: One of the most common requirement for every technical consultant working in oracle and Related technologies is to find out specific database tables which hold a particular piece of…
Read MoreDescription: EAM enables you to generate Work Orders automatically using a preventive maintenance schedule, based on Runtime Rules, Day Interval Rules, and List Dates. API used for while generating Preventive…
Read MoreDescription: Construction units are defined at the organization level, and can include only those activities that are assigned to the same inventory organization. However, you can query construction units associated…
Read MoreDescription: Oracle Enterprise Asset Management provides several open interfaces and APIs, enabling you to link with non-Oracle applications, applications you build, and applications on other computers. API used to maintain…
Read MoreDescription: Failure Analysis enables you to track an asset failure from the time it is reported until its resolution. Statistics from your collected failure data provide you with information on…
Read MoreDescription: A capital project, defined as any project which requires capital flows for completion, usually refers to a project which requires large sums of capital. Purpose of this report is to display Project…
Read More