View: JAI_AP_TDS_TH_VSITE_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_AP_TDS_TH_VSITE_V

View Text

SELECT A.VENDOR_ID
, E.TDS_VENDOR_TYPE_LOOKUP_CODE
, B.VENDOR_SITE_ID
, C.PAN_NO PAN_NO
, D.ORG_TAN_NUM TAN_NO
, F.SECTION_CODE
, F.SECTION_TYPE
, F.THRESHOLD_SETUP_NAME
, F.THRESHOLD_HDR_ID
, F.EXCEPTION_SETUP_FLAG
, F.MULTIPLE_RATE_SETUP
FROM PO_VENDORS A
, PO_VENDOR_SITES_ALL B
, JAI_AP_TDS_VENDOR_HDRS C
, JAI_AP_TDS_ORG_TAN_V D
, JAI_AP_TDS_VNDR_TYPE_V E
, JAI_AP_TDS_THHOLD_HDRS F
WHERE A.VENDOR_ID = B.VENDOR_ID
AND B.VENDOR_ID = C.VENDOR_ID
AND B.VENDOR_SITE_ID = C.VENDOR_SITE_ID
AND B.ORG_ID = D.ORGANIZATION_ID
AND A.VENDOR_ID = E.VENDOR_ID
AND E.TDS_VENDOR_TYPE_LOOKUP_CODE = F.VENDOR_TYPE_LOOKUP_CODE
AND ( ( F.EXCEPTION_SETUP_FLAG = 'N'
AND NOT EXISTS (SELECT '1'
FROM JAI_AP_TDS_THHOLD_XCEPS P
, JAI_AP_TDS_THHOLD_HDRS Q
WHERE P.THRESHOLD_HDR_ID = Q.THRESHOLD_HDR_ID
AND P.VENDOR_ID = C.VENDOR_ID
AND P.ORG_TAN = D.ORG_TAN_NUM
AND P.VENDOR_PAN = C.PAN_NO
AND Q.THRESHOLD_HDR_ID <> F.THRESHOLD_HDR_ID
AND Q.VENDOR_TYPE_LOOKUP_CODE = F.VENDOR_TYPE_LOOKUP_CODE
AND Q.SECTION_CODE = F.SECTION_CODE ) ) OR ( F.EXCEPTION_SETUP_FLAG = 'Y'
AND EXISTS (SELECT '1'
FROM JAI_AP_TDS_THHOLD_XCEPS JATHZX
WHERE JATHZX.VENDOR_ID = C.VENDOR_ID /* BUG 5093948. ADDED THE FOLLOWING CONDITION */
AND JATHZX.THRESHOLD_HDR_ID = F.THRESHOLD_HDR_ID
AND JATHZX.ORG_TAN = D.ORG_TAN_NUM
AND JATHZX.VENDOR_PAN = C.PAN_NO ) ) )

Columns