You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    How to add SQL query in where statement for creating parameters and the list of values

    in Learning 1 comment

    Summary:

    Hi I need to create parameter for country can anyone help me how to write the line in where statement and list of values ,

    Select PAPF.PERSON_NUMBER,

    per_extract_utility.get_territory_name(paff.country) Country

    from PER_ALL_PEOPLE_F PAPF

    ,PER_PERSON_NAMES_F PPNF

    ,PER_addresses_f paff
    ,per_person_addr_usages_f ppauf

    where PAPF.PERSON_ID = PPNF.PERSON_ID
    AND PPNF.NAME_TYPE = 'GLOBAL'

    AND PAPF.PERSON_ID = ppauf.PERSON_ID(+)
    AND ppauf.address_id = paff.address_id(+)


    Content (please ensure you mask any confidential information):


    Version (include the version you are using, if applicable):

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!