HZ PARTIES LINK TO ORGANIZATION TABLE LINK

Trang chủ » Hr_organization_units Table In R12 » HZ PARTIES LINK TO ORGANIZATION TABLE LINK

Có thể bạn quan tâm

Tuesday, 28 July 2015

HZ PARTIES LINK TO ORGANIZATION TABLE LINK

SELECT hrl.country, hroutl_bg.NAME bg, hroutl_bg.organization_id, lep.legal_entity_id, lep.NAME legal_entity, hroutl_ou.NAME ou_name, hroutl_ou.organization_id org_id, hrl.location_id, hrl.location_code, glev.FLEX_SEGMENT_VALUE FROM xle_entity_profiles lep, xle_registrations reg, hr_locations_all hrl, hz_parties hzp, fnd_territories_vl ter, hr_operating_units hro, hr_all_organization_units_tl hroutl_bg, hr_all_organization_units_tl hroutl_ou, hr_organization_units gloperatingunitseo, gl_legal_entities_bsvs glev WHERE lep.transacting_entity_flag = 'Y' AND lep.party_id = hzp.party_id AND lep.legal_entity_id = reg.source_id AND reg.source_table = 'XLE_ENTITY_PROFILES' AND hrl.location_id = reg.location_id AND reg.identifying_flag = 'Y' AND ter.territory_code = hrl.country AND lep.legal_entity_id = hro.default_legal_context_id AND gloperatingunitseo.organization_id = hro.organization_id AND hroutl_bg.organization_id = hro.business_group_id AND hroutl_ou.organization_id = hro.organization_id AND glev.legal_entity_id = lep.legal_entity_id /* Formatted on 7/28/2015 7:48:07 PM (QP5 v5.240.12305.39446) */SELECT hzp.* FROM hz_parties hzp, --Table xle_entity_profiles lep, --Table xle_registrations reg, hr_locations_all hrl, fnd_territories_vl ter, hr_operating_units hro --Table WHERE 1 = 1 AND lep.party_id = hzp.party_id --Link AND lep.legal_entity_id = reg.source_id AND hrl.location_id = reg.location_id AND ter.territory_code = hrl.country AND lep.legal_entity_id = hro.default_legal_context_id --Link Posted by at 22:25 Labels: HZ TO ORG

No comments:

Post a Comment

Newer Post Older Post Home Subscribe to: Post Comments (Atom)

About Me

My photo Elangovan Ragavan இளங்கோவன் ராகவன் எண்ணிய முடிதல் வேண்டும், நல்லவே யெண்ணல் வேண்டும்; திண்ணிய நெஞ்சம் வேண்டும், தெளிந்த நல் லறிவு வேண்டும்; பண்ணிய பாவமெல்லாம் பரிதி முன் பனியே போல, நண்ணிய நின்மு னிங்கு நசித்திட வேண்டும் அன்னாய்! View my complete profile

Oracle GRC

Oracle GRC Oracle Advanced Controls 11g Applications Certified Implementation Specialist

Followers

Live Viewers

Total Pageviews

Labels

  • .lst file (1)
  • About Page in OAF (3)
  • ADF (2)
  • Advanced Collections (1)
  • Advanced PL/SQL (18)
  • AIGS (10)
  • AIM Document (3)
  • Alert (7)
  • AME (17)
  • AOL (6)
  • AP Functional Accounting (17)
  • AP Payments (6)
  • AP_Module (84)
  • APEX (70)
  • API'S / INTREFACES (77)
  • Application Short Name (2)
  • approved supplier list (2)
  • APPS (11)
  • AR Functional (10)
  • AR_Query (72)
  • Back-to-Back Order Cycle (2)
  • Bank Query (34)
  • BOM (2)
  • Cash Management (8)
  • concurrent program (49)
  • Contorl file ctl (7)
  • Contorl file SQL *Loader (4)
  • Current Login Users (1)
  • custom.pll (7)
  • Customer (13)
  • Data Extraction (57)
  • Data Model (2)
  • Date Format (7)
  • DBA (114)
  • DELETE_QUERY (3)
  • DFF (7)
  • Documents (1)
  • DROP SHIP Order Flow (1)
  • Dummy Table (1)
  • EAM (16)
  • elango (6)
  • ERROR (28)
  • Executable (21)
  • FA (18)
  • FlexFields (8)
  • FND LOG (1)
  • FND_LOAD (13)
  • form personalization (52)
  • Forms (23)
  • FSG Report (1)
  • FUNCTIONAL (130)
  • gl (84)
  • GL Accounting (12)
  • GL Flow (3)
  • Global (1)
  • GRC (31)
  • GRC Function (1)
  • GRC Gertification (1)
  • GRC Screen (13)
  • GRC Tech (20)
  • HRMS (87)
  • Hyperion (7)
  • HZ TO ORG (1)
  • ICX - Oracle Self-Service Web Applications (2)
  • iExpenses (8)
  • IF (1)
  • India Localization (5)
  • Inventory_Details (69)
  • iprocurement (4)
  • ITEM_TEMPLATE (1)
  • java (8)
  • Legal entity (1)
  • Lexical & Bind (2)
  • LINKS IN ALL TABLES (6)
  • Lookup value (1)
  • Materialized View (2)
  • MO:Security Profile (2)
  • Multi-Org (24)
  • My Favorited Links (2)
  • MY FAVOURITES (2)
  • O2C CYCLE (28)
  • OBIEE (74)
  • ODI (1)
  • OM (23)
  • OM Setup (9)
  • Oracle (2)
  • ORACLE -Orbital Relational Analytical Computing Logical Equation (5)
  • Oracle Certification (1)
  • Oracle Discoverer (4)
  • Oracle Interview Questions (45)
  • Oracle Pricing (9)
  • Oracle Property Manager (5)
  • Oracle Setup Steps (1)
  • Oracle Standard Reports (25)
  • org (5)
  • OUM Methodology (1)
  • Outlook (1)
  • Output type in Oracle (1)
  • P2P Cycle (17)
  • Password in EBS (3)
  • Payroll (2)
  • Personalize OAF Pages (16)
  • PL/SQL (53)
  • PO (83)
  • Printer Assign process (1)
  • profile (10)
  • Projects (58)
  • Pure Silence for Life... :) (1)
  • QUERY (3)
  • R12 (3)
  • RDF report (5)
  • Receipt (1)
  • Reconciled Payments (2)
  • REPORT (15)
  • REPORT NAMES (1)
  • REPORT_QUERY (12)
  • request group (2)
  • Request Set (3)
  • Reset the po (2)
  • Responsibility (24)
  • RICE (1)
  • Row count (1)
  • Shell Script (6)
  • Shortcut Key (1)
  • SLA (13)
  • SOB (3)
  • SQL (98)
  • SRW.user_exit (2)
  • SUB_QUERY (1)
  • Supplier (29)
  • sysadmin (17)
  • Tables (71)
  • TAX (17)
  • TCA R12 (7)
  • technical (4)
  • Time Formets (3)
  • TOAD (3)
  • Trace (3)
  • UPDATE QUERY (20)
  • User Hooks (1)
  • USER_RES_MENU (14)
  • Valueset (18)
  • Videos (6)
  • VPD in Oracle (1)
  • Web ADI in Oracle (4)
  • Windows XP (1)
  • WIP (2)
  • Workflow (5)
  • XLA_SUB_LEDGER (20)
  • xml (91)

Blog Archive

  • ▼  2015 (254)
    • ▼  July (79)
      • HZ PARTIES LINK TO ORGANIZATION TABLE LINK
      • Extract profile option values for all possible levels
      • Basic Form Personalization steps in oracla apps
      • Increase Session Timeout Time in Orale apps
      • Query to List all the responsibilities attached to...
      • Find Table and Column Name Query in oralce Apps
      • Link between Order Management and Account Receivab...
      • Sales Order Line Status Flow and Meaning
      • Colors in Concurrent Request Manager Screen in ora...
      • API code to Create Credit Memo and apply it to inv...
      • Bom Explosion Query
      • Query to display BOL, MBOL, Trip details for a Sal...
      • Drop Ship Order Query in oracle apps
      • Finding Responsibility of a Form in oralce apps
      • Forms Personalizations Not Visible in Oracle Apps
      • Inter-Organization Transfer Main table list
      • SQL query for Concurrent Request Paused Jobs
      • SQL Query for Concurrent Request Failures
      • SQL Query for Interface Managers
      • iRecruitment Internal Vacancies/Jobs SQL Query
      • Price Book in Advance Pricing in Oracle Apps
      • TCA Process flow for managing, searching, creating...
      • Project Accounting – Overview of Oracle Apps R12
      • MULTI – ORG Concept in Oracle Applications R12
      • Multi - Org Concept in Oracle Apps R12
      • Oracle Inventory: Defining Item (Item Master) in R12
      • Oracle Inventory: Defining Subinventories in R12
      • Oracle Inventory: Defining Locators in R12
      • Oracle Inventory: Defining Rules in R12
      • Oracle Inventory Enterprise Structure in R12
      • Oracle Inventory Defining Location in R12
      • Oracle Inventory Defining Calendar in R12
      • Oracle Inventory Implementation Introduction in R12
      • Oracle Inventory Flexfields Implementation in R12
      • Overview of Inventory Transactions in R12
      • Oracle Inventory: Item Attributes process in R12
      • Oracle Inventory : Item in R12
      • Oracle Inventory Unit Of Measure Implementation in...
      • Oracle Inventory: Units of Measure in R12
      • Oracle Inventory: Implementation Considerations in...
      • Oracle Inventory: Organization Hierarchy in R12
      • Oracle Inventory: Shipping Network and Other setups
      • Subinventory and Locator process in oracle apps
      • Inventory Organizations process in oracle apps
      • Overview of Oracle Inventory
      • Oracle Flex fields Oracle flexfields is one of...
      • Oracle E-Business Suite Modules
      • Error in Pack Slip Generation during Ship Confirma...
      • Order To Cash full flow in oralce apps
      • Rdf Report Creation Process in oracle apps
      • Multi-Org Structure in Oracle 11i Applications – a...
      • Payment Method In Oralce Apps
      • MANUAL SHIP CONFIRM PROCESS IN ORDER MANAGEMENT OR...
      • Cascade Receipts in Oracle Purchasing - R12.2
      • Express Receipts in Oracle Purchasing - R12.2
      • Substitute Receipts in Oracle Purchasing - R12.2
      • Un-Ordered Receipts in Oracle Purchasing - R12.2
      • RMA - Return Material Authorizations in R12.2
      • IR & ISO - Internal Sales Order Cycle with Setup S...
      • Oracle Order Management Setup Document in R12.2
      • Inventory Module Setup in Oracle apps
      • ORACLE GENERAL LEDGER PROCESS
      • FRM-40735:ON-UPDATE New Locations in Oracle HRMS
      • Updating Unit List Price in Blanket Sales Agreemen...
      • Allow Negative Quantity functionality in Shipping ...
      • How to enable the MOAC parameter “Operating Unit” ...
      • White Paper on Advanced Approval using Approval Ma...
      • iProcurement Setup Document and it's basic flows i...
      • Unable to View or Add any Items in Sales Orders in...
      • Security Hierarchy functionality Setups and Flow i...
      • Move Order Approval Process in Oracle apps
      • How to Remove Error Workflow Notifications from Wo...
      • Contract Purchase Agreement Creation Process in or...
      • BSA - Blanket Sales Agreement and Releases in Oracle
      • Updating Unit List Price in Blanket Sales Agreemen...
      • Blanket Purchase Agreement (BPA) with Minimum Rele...
      • BPA - Blanket Purchase Agreement with Cumulative P...
      • Price Limit control for Blanket release in Oracle ...
      • BPA With Allow Price Override and Price Limit Func...

Từ khóa » Hr_organization_units Table In R12