eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ITG_SP_PO_PART_SOLDTO_V

Source

View Text - Preformatted


SELECT pha.po_header_id, pha.bill_to_location_id, pha.agent_id, hrLoc.inventory_organization_id invorgid, orgDef.set_of_books_id, orgdef.organization_name, orgdef.organization_code partnrid, 'SoldTo' partnrtype, glsob.currency_code currency, hrloc.inventory_organization_id partnridx, hrloc.bill_to_site_flag ua_sold_billflag, hrloc.ship_to_site_flag ua_sold_shipflag, hrloc.receiving_site_flag ua_sold_recflag, hrloc.address_line_1, hrloc.address_line_2, hrloc.address_line_3, NULL addrtype, hrloc.town_or_city city, hrloc.country, itg_x_utils.getCounty(hrLoc.style, hrLoc.region_1, hrLoc.region_2) county, hrLocTL.description site_descriptn, hrLoc.postal_code, itg_x_utils.getState(hrLoc.style, hrLoc.region_1, hrLoc.region_2) stateprovn, hrLoc.telephone_number_1 telephone, per.full_name contact_name, per.email_address contact_email, per.work_telephone contact_phone FROM gl_sets_of_books glSOB, hr_locations_all hrLoc, hr_locations_all_tl hrLocTL, per_people_f per, po_headers_all pha, org_organization_definitions orgDef WHERE glSOB.set_of_books_id = orgDef.set_of_books_id AND orgDef.organization_id = hrLoc.inventory_organization_id AND per.person_id (+) = pha.agent_id AND hrLoc.location_id (+) = pha.bill_to_location_id AND hrLocTL.location_id (+) = pha.bill_to_location_id AND hrLocTL.LANGUAGE(+) = userenv('LANG') AND nvl(per.effective_end_date,sysdate+1) > sysdate

View Text - HTML Formatted

SELECT PHA.PO_HEADER_ID
, PHA.BILL_TO_LOCATION_ID
, PHA.AGENT_ID
, HRLOC.INVENTORY_ORGANIZATION_ID INVORGID
, ORGDEF.SET_OF_BOOKS_ID
, ORGDEF.ORGANIZATION_NAME
, ORGDEF.ORGANIZATION_CODE PARTNRID
, 'SOLDTO' PARTNRTYPE
, GLSOB.CURRENCY_CODE CURRENCY
, HRLOC.INVENTORY_ORGANIZATION_ID PARTNRIDX
, HRLOC.BILL_TO_SITE_FLAG UA_SOLD_BILLFLAG
, HRLOC.SHIP_TO_SITE_FLAG UA_SOLD_SHIPFLAG
, HRLOC.RECEIVING_SITE_FLAG UA_SOLD_RECFLAG
, HRLOC.ADDRESS_LINE_1
, HRLOC.ADDRESS_LINE_2
, HRLOC.ADDRESS_LINE_3
, NULL ADDRTYPE
, HRLOC.TOWN_OR_CITY CITY
, HRLOC.COUNTRY
, ITG_X_UTILS.GETCOUNTY(HRLOC.STYLE
, HRLOC.REGION_1
, HRLOC.REGION_2) COUNTY
, HRLOCTL.DESCRIPTION SITE_DESCRIPTN
, HRLOC.POSTAL_CODE
, ITG_X_UTILS.GETSTATE(HRLOC.STYLE
, HRLOC.REGION_1
, HRLOC.REGION_2) STATEPROVN
, HRLOC.TELEPHONE_NUMBER_1 TELEPHONE
, PER.FULL_NAME CONTACT_NAME
, PER.EMAIL_ADDRESS CONTACT_EMAIL
, PER.WORK_TELEPHONE CONTACT_PHONE
FROM GL_SETS_OF_BOOKS GLSOB
, HR_LOCATIONS_ALL HRLOC
, HR_LOCATIONS_ALL_TL HRLOCTL
, PER_PEOPLE_F PER
, PO_HEADERS_ALL PHA
, ORG_ORGANIZATION_DEFINITIONS ORGDEF
WHERE GLSOB.SET_OF_BOOKS_ID = ORGDEF.SET_OF_BOOKS_ID
AND ORGDEF.ORGANIZATION_ID = HRLOC.INVENTORY_ORGANIZATION_ID
AND PER.PERSON_ID (+) = PHA.AGENT_ID
AND HRLOC.LOCATION_ID (+) = PHA.BILL_TO_LOCATION_ID
AND HRLOCTL.LOCATION_ID (+) = PHA.BILL_TO_LOCATION_ID
AND HRLOCTL.LANGUAGE(+) = USERENV('LANG')
AND NVL(PER.EFFECTIVE_END_DATE
, SYSDATE+1) > SYSDATE