VIEW: APPS.JAI_AP_TDS_TH_VSITE_V

Source

View Text - Preformatted

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 ) ) )

View Text - HTML Formatted

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 ) ) )