View: JAI_AP_TDS_THHOLD_EXCEPTION_V

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

View Text

SELECT G.TDS_VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE
, A.VENDOR_ID
, A.VENDOR_NAME
, C.VENDOR_PAN PAN_NO
, C.ORG_TAN ORG_TAN_NUM
, E.SECTION_TYPE
, E.SECTION_CODE
, /* BUG 5093948. ADDED THRESHOLD HDR ID */ E.THRESHOLD_HDR_ID
, /* BUG 13359892. ADDED PROSPECTIVE_FLG */ C.PROSPECTIVE_FLAG
FROM PO_VENDORS A
, JAI_AP_TDS_THHOLD_XCEPS C
, JAI_AP_TDS_THHOLD_HDRS E
, JAI_AP_TDS_VNDR_TYPE_V G
WHERE A.VENDOR_ID = C.VENDOR_ID
AND C.THRESHOLD_HDR_ID = E.THRESHOLD_HDR_ID
AND A.VENDOR_ID = G.VENDOR_ID

Columns