VIEW: APPS.PO_VENDOR_SITES_PAY_AP_V

Source

View Text - Preformatted

SELECT PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE , PVS.VENDOR_SITE_ID VENDOR_SITE_ID , PVS.VENDOR_ID VENDOR_ID , PVS.ADDRESS_LINE1 ADDRESS_LINE1 , PVS.ADDRESS_LINE2 ADDRESS_LINE2 , PVS.ADDRESS_LINE3 ADDRESS_LINE3 , PVS.ADDRESS_LINE4 ADDRESS_LINE4 , PVS.ADDRESS_STYLE ADDRESS_STYLE , PVS.CITY CITY , PVS.COUNTY COUNTY , PVS.STATE STATE , PVS.PROVINCE PROVINCE , PVS.ZIP ZIP , PVS.COUNTRY COUNTRY , PVS.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE , PVS.TERMS_ID TERMS_ID , AT.NAME TERMS_NAME , PVS.PAY_GROUP_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE , PVS.TERMS_DATE_BASIS TERMS_DATE_BASIS , ALC2.DISPLAYED_FIELD TERMS_DATE_BASIS_DISP , PVS.ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID , PVS.INVOICE_AMOUNT_LIMIT INVOICE_AMOUNT_LIMIT , PVS.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID , ADS.DISTRIBUTION_SET_NAME DISTRIBUTION_SET_NAME , PVS.PAYMENT_PRIORITY PAYMENT_PRIORITY , PVS.PAY_DATE_BASIS_LOOKUP_CODE PAY_DATE_BASIS_LOOKUP_CODE , PVS.HOLD_FUTURE_PAYMENTS_FLAG HOLD_FUTURE_PAYMENTS_FLAG , PVS.EXCLUDE_FREIGHT_FROM_DISCOUNT EXCLUDE_FREIGHT_FROM_DISCOUNT , PVS.ALLOW_AWT_FLAG ALLOW_AWT_FLAG , PVS.AWT_GROUP_ID AWT_GROUP_ID , AWT.NAME AWT_GROUP_NAME , FT.TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME , DECODE(SIGN(TO_DATE(TO_CHAR(PVS.INACTIVE_DATE,'YYYY/MM/DD'),'YYYY/MM/DD') - TO_DATE(TO_CHAR(SYSDATE,'YYYY/MM/DD'),'YYYY/MM/DD')),-1,'N',0,'N','Y') ACTIVE_FLAG , PVS.HOLD_ALL_PAYMENTS_FLAG HOLD_ALL_PAYMENTS_FLAG , PVS.ALWAYS_TAKE_DISC_FLAG ALWAYS_TAKE_DISC_FLAG , PVS.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE , PVS.ORG_ID , PVS.PARTY_SITE_ID , IEP.PAYEE_PARTY_ID , IEP.PAYMENT_FUNCTION , IEP.BANK_CHARGE_BEARER , IEP.SETTLEMENT_PRIORITY , IEP.EXCLUSIVE_PAYMENT_FLAG , PVS.PREPAY_CODE_COMBINATION_ID ,PVS.PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID ,AWT1.NAME PAY_AWT_GROUP_NAME FROM AP_SUPPLIER_SITES PVS, AP_SUPPLIERS PV, IBY_EXTERNAL_PAYEES_ALL IEP, FND_TERRITORIES_VL FT, AP_TERMS AT, AP_LOOKUP_CODES ALC2, AP_DISTRIBUTION_SETS_ALL ADS, AP_AWT_GROUPS AWT, AP_AWT_GROUPS AWT1 WHERE PVS.COUNTRY = FT.TERRITORY_CODE (+) AND AT.TERM_ID (+) = PVS.TERMS_ID AND ALC2.LOOKUP_CODE (+) = PVS.TERMS_DATE_BASIS AND ALC2.LOOKUP_TYPE (+) = 'TERMS DATE BASIS' AND AWT.GROUP_ID (+) = PVS.AWT_GROUP_ID AND ADS.DISTRIBUTION_SET_ID (+) = PVS.DISTRIBUTION_SET_ID AND PVS.PAY_SITE_FLAG = 'Y' AND PVS.VENDOR_ID = PV.VENDOR_ID AND PV.PARTY_ID = IEP.PAYEE_PARTY_ID AND PVS.VENDOR_SITE_ID = IEP.SUPPLIER_SITE_ID(+) AND AWT1.GROUP_ID(+)=PVS.PAY_AWT_GROUP_ID

View Text - HTML Formatted

SELECT PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE
, PVS.VENDOR_SITE_ID VENDOR_SITE_ID
, PVS.VENDOR_ID VENDOR_ID
, PVS.ADDRESS_LINE1 ADDRESS_LINE1
, PVS.ADDRESS_LINE2 ADDRESS_LINE2
, PVS.ADDRESS_LINE3 ADDRESS_LINE3
, PVS.ADDRESS_LINE4 ADDRESS_LINE4
, PVS.ADDRESS_STYLE ADDRESS_STYLE
, PVS.CITY CITY
, PVS.COUNTY COUNTY
, PVS.STATE STATE
, PVS.PROVINCE PROVINCE
, PVS.ZIP ZIP
, PVS.COUNTRY COUNTRY
, PVS.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, PVS.TERMS_ID TERMS_ID
, AT.NAME TERMS_NAME
, PVS.PAY_GROUP_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE
, PVS.TERMS_DATE_BASIS TERMS_DATE_BASIS
, ALC2.DISPLAYED_FIELD TERMS_DATE_BASIS_DISP
, PVS.ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID
, PVS.INVOICE_AMOUNT_LIMIT INVOICE_AMOUNT_LIMIT
, PVS.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, ADS.DISTRIBUTION_SET_NAME DISTRIBUTION_SET_NAME
, PVS.PAYMENT_PRIORITY PAYMENT_PRIORITY
, PVS.PAY_DATE_BASIS_LOOKUP_CODE PAY_DATE_BASIS_LOOKUP_CODE
, PVS.HOLD_FUTURE_PAYMENTS_FLAG HOLD_FUTURE_PAYMENTS_FLAG
, PVS.EXCLUDE_FREIGHT_FROM_DISCOUNT EXCLUDE_FREIGHT_FROM_DISCOUNT
, PVS.ALLOW_AWT_FLAG ALLOW_AWT_FLAG
, PVS.AWT_GROUP_ID AWT_GROUP_ID
, AWT.NAME AWT_GROUP_NAME
, FT.TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME
, DECODE(SIGN(TO_DATE(TO_CHAR(PVS.INACTIVE_DATE
, 'YYYY/MM/DD')
, 'YYYY/MM/DD') - TO_DATE(TO_CHAR(SYSDATE
, 'YYYY/MM/DD')
, 'YYYY/MM/DD'))
, -1
, 'N'
, 0
, 'N'
, 'Y') ACTIVE_FLAG
, PVS.HOLD_ALL_PAYMENTS_FLAG HOLD_ALL_PAYMENTS_FLAG
, PVS.ALWAYS_TAKE_DISC_FLAG ALWAYS_TAKE_DISC_FLAG
, PVS.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, PVS.ORG_ID
, PVS.PARTY_SITE_ID
, IEP.PAYEE_PARTY_ID
, IEP.PAYMENT_FUNCTION
, IEP.BANK_CHARGE_BEARER
, IEP.SETTLEMENT_PRIORITY
, IEP.EXCLUSIVE_PAYMENT_FLAG
, PVS.PREPAY_CODE_COMBINATION_ID
, PVS.PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID
, AWT1.NAME PAY_AWT_GROUP_NAME
FROM AP_SUPPLIER_SITES PVS
, AP_SUPPLIERS PV
, IBY_EXTERNAL_PAYEES_ALL IEP
, FND_TERRITORIES_VL FT
, AP_TERMS AT
, AP_LOOKUP_CODES ALC2
, AP_DISTRIBUTION_SETS_ALL ADS
, AP_AWT_GROUPS AWT
, AP_AWT_GROUPS AWT1
WHERE PVS.COUNTRY = FT.TERRITORY_CODE (+)
AND AT.TERM_ID (+) = PVS.TERMS_ID
AND ALC2.LOOKUP_CODE (+) = PVS.TERMS_DATE_BASIS
AND ALC2.LOOKUP_TYPE (+) = 'TERMS DATE BASIS'
AND AWT.GROUP_ID (+) = PVS.AWT_GROUP_ID
AND ADS.DISTRIBUTION_SET_ID (+) = PVS.DISTRIBUTION_SET_ID
AND PVS.PAY_SITE_FLAG = 'Y'
AND PVS.VENDOR_ID = PV.VENDOR_ID
AND PV.PARTY_ID = IEP.PAYEE_PARTY_ID
AND PVS.VENDOR_SITE_ID = IEP.SUPPLIER_SITE_ID(+)
AND AWT1.GROUP_ID(+)=PVS.PAY_AWT_GROUP_ID