VIEW: APPS.ITG_SP_REL_LINE_PART_EMPL_V

Source

View Text - Preformatted

SELECT Pda.Po_Distribution_Id, Pda.Po_Header_Id, Pda.Po_Line_Id, Pda.Line_Location_Id, Pda.Deliver_To_Location_Id, Pda.Deliver_To_Person_Id, Hrloc.Location_Code Name, Per.Employee_Number Partnrid, 'Employee' Partnrtype, Hrloctl.Description Descriptn_Partner, To_Char(Pda.Deliver_To_Location_Id) Partnridx, Decode(Hrloc.Tax_Name, Null, 0, 1) Taxexempt, To_Char(Pda.Line_Location_Id) Ua_Ref_Schedlid, To_Char(Pda.Po_Distribution_Id) Ua_Ref_Distrid, Itg_X_Utils.Getrequistnid(Pda.Req_Distribution_Id) Ua_Requisitnid, Hrloc.Address_Line_1, Hrloc.Address_Line_2, Hrloc.Address_Line_3, Hrloc.Town_Or_City City, Hrloc.Country, Itg_X_Utils.Getcounty(Hrloc.Style, Hrloc.Region_1, Hrloc.Region_2) County, Hrloctl.Description Descriptn_Addrs, 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 Hr_Locations_All Hrloc, Hr_Locations_All_Tl Hrloctl, Per_People_F Per, Po_Distributions_All Pda WHERE Per.Person_Id (+) = Pda.Deliver_To_Person_Id And Hrloc.Location_Id (+) = Pda.Deliver_To_Location_Id And Hrloctl.Location_Id (+) = Pda.Deliver_To_Location_Id And hrLocTL.language (+)= userenv('LANG') AND nvl(per.effective_end_date, sysdate+1) > sysdate AND NVL(pda.distribution_type,'xx') <> 'PREPAYMENT'

View Text - HTML Formatted

SELECT PDA.PO_DISTRIBUTION_ID
, PDA.PO_HEADER_ID
, PDA.PO_LINE_ID
, PDA.LINE_LOCATION_ID
, PDA.DELIVER_TO_LOCATION_ID
, PDA.DELIVER_TO_PERSON_ID
, HRLOC.LOCATION_CODE NAME
, PER.EMPLOYEE_NUMBER PARTNRID
, 'EMPLOYEE' PARTNRTYPE
, HRLOCTL.DESCRIPTION DESCRIPTN_PARTNER
, TO_CHAR(PDA.DELIVER_TO_LOCATION_ID) PARTNRIDX
, DECODE(HRLOC.TAX_NAME
, NULL
, 0
, 1) TAXEXEMPT
, TO_CHAR(PDA.LINE_LOCATION_ID) UA_REF_SCHEDLID
, TO_CHAR(PDA.PO_DISTRIBUTION_ID) UA_REF_DISTRID
, ITG_X_UTILS.GETREQUISTNID(PDA.REQ_DISTRIBUTION_ID) UA_REQUISITNID
, HRLOC.ADDRESS_LINE_1
, HRLOC.ADDRESS_LINE_2
, HRLOC.ADDRESS_LINE_3
, HRLOC.TOWN_OR_CITY CITY
, HRLOC.COUNTRY
, ITG_X_UTILS.GETCOUNTY(HRLOC.STYLE
, HRLOC.REGION_1
, HRLOC.REGION_2) COUNTY
, HRLOCTL.DESCRIPTION DESCRIPTN_ADDRS
, 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 HR_LOCATIONS_ALL HRLOC
, HR_LOCATIONS_ALL_TL HRLOCTL
, PER_PEOPLE_F PER
, PO_DISTRIBUTIONS_ALL PDA
WHERE PER.PERSON_ID (+) = PDA.DELIVER_TO_PERSON_ID
AND HRLOC.LOCATION_ID (+) = PDA.DELIVER_TO_LOCATION_ID
AND HRLOCTL.LOCATION_ID (+) = PDA.DELIVER_TO_LOCATION_ID
AND HRLOCTL.LANGUAGE (+)= USERENV('LANG')
AND NVL(PER.EFFECTIVE_END_DATE
, SYSDATE+1) > SYSDATE
AND NVL(PDA.DISTRIBUTION_TYPE
, 'XX') <> 'PREPAYMENT'