eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.JAI_AP_TDS_THHOLD_EXCEPTION_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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