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.

APPS.JA_JAINER1_XMLP_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 1743: JAI_CMN_VENDOR_SITES JIPV

1739: ,0)
1740: ,0)) CREDIT_AVAILED_ON_INPUTS_VEND
1741: FROM
1742: JAI_CMN_RG_23AC_II_TRXS JIRP,
1743: JAI_CMN_VENDOR_SITES JIPV
1744: WHERE LOCATION_ID = P_LOCATION_ID
1745: AND ORGANIZATION_ID = P_ORGANIZATION_ID
1746: AND JIRP.VENDOR_ID = JIPV.VENDOR_ID
1747: AND JIRP.VENDOR_SITE_ID = JIPV.VENDOR_SITE_ID

Line 1931: JAI_CMN_VENDOR_SITES JIPV

1927: ,0)
1928: ,0)) CREDIT_AVAILED_ON_INPUTS
1929: FROM
1930: JAI_CMN_RG_23AC_II_TRXS JIRP,
1931: JAI_CMN_VENDOR_SITES JIPV
1932: WHERE LOCATION_ID = P_LOCATION_ID
1933: AND ORGANIZATION_ID = P_ORGANIZATION_ID
1934: AND JIRP.VENDOR_ID = JIPV.VENDOR_ID
1935: AND JIRP.VENDOR_SITE_ID = JIPV.VENDOR_SITE_ID

Line 2026: JAI_CMN_VENDOR_SITES JIPV

2022: ,0)
2023: FROM
2024: JAI_CMN_RG_OTHERS JRO,
2025: JAI_CMN_RG_23AC_II_TRXS RG23,
2026: JAI_CMN_VENDOR_SITES JIPV
2027: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2028: AND RG23.VENDOR_ID = JIPV.VENDOR_ID
2029: AND RG23.VENDOR_SITE_ID = JIPV.VENDOR_SITE_ID
2030: AND ( JIPV.VENDOR_TYPE IN ( 'Manufacturer' , 'Importer' )

Line 2123: JAI_CMN_VENDOR_SITES JIPV

2119: ,0)
2120: FROM
2121: JAI_CMN_RG_OTHERS JRO,
2122: JAI_CMN_RG_23AC_II_TRXS RG23,
2123: JAI_CMN_VENDOR_SITES JIPV
2124: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2125: AND RG23.VENDOR_ID = JIPV.vendor_id (+)
2126: AND RG23.VENDOR_SITE_ID = JIPV.vendor_site_id (+)
2127: AND JIPV.VENDOR_TYPE IN ( 'First Stage Dealer' , 'Second Stage Dealer' )

Line 2236: JAI_CMN_VENDOR_SITES JIPV )

2232: AND JIRP.VENDOR_ID || JIRP.VENDOR_SITE_ID NOT IN (
2233: SELECT
2234: JIPV.VENDOR_ID || JIPV.VENDOR_SITE_ID
2235: FROM
2236: JAI_CMN_VENDOR_SITES JIPV )
2237: AND JIRP.LOCATION_ID = P_LOCATION_ID
2238: AND JIRP.ORGANIZATION_ID = P_ORGANIZATION_ID
2239: AND TRUNC(JIRP.CREATION_DATE) >= P_START_DATE
2240: AND TRUNC(JIRP.CREATION_DATE) <= TRUNC(NVL(P_END_DATE

Line 2654: JAI_CMN_VENDOR_SITES JIPV

2650: ,0)
2651: FROM
2652: JAI_CMN_RG_OTHERS JRO,
2653: JAI_CMN_RG_23AC_II_TRXS RG23,
2654: JAI_CMN_VENDOR_SITES JIPV
2655: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2656: AND RG23.VENDOR_ID = JIPV.VENDOR_ID
2657: AND RG23.VENDOR_SITE_ID = JIPV.VENDOR_SITE_ID
2658: AND ( JIPV.VENDOR_TYPE IN ( 'Manufacturer' , 'Importer' )

Line 2751: JAI_CMN_VENDOR_SITES JIPV

2747: ,0)
2748: FROM
2749: JAI_CMN_RG_OTHERS JRO,
2750: JAI_CMN_RG_23AC_II_TRXS RG23,
2751: JAI_CMN_VENDOR_SITES JIPV
2752: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2753: AND RG23.VENDOR_ID = JIPV.vendor_id (+)
2754: AND RG23.VENDOR_SITE_ID = JIPV.vendor_site_id (+)
2755: AND JIPV.VENDOR_TYPE IN ( 'First Stage Dealer' , 'Second Stage Dealer' )