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_INVENTORY_ORGS

Line 48: JAI_CMN_INVENTORY_ORGS

44: SELECT
45: EC_CODE
46: INTO V_EC_CODE
47: FROM
48: JAI_CMN_INVENTORY_ORGS
49: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
50: AND LOCATION_ID = P_LOCATION_ID;
51: RETURN (V_EC_CODE);
52: EXCEPTION

Line 1823: JAI_CMN_INVENTORY_ORGS JIHO

1819: ,0)
1820: ,0)) CREDIT_AVAILED_ON_INPUTS
1821: FROM
1822: JAI_CMN_RG_23AC_II_TRXS JIRP,
1823: JAI_CMN_INVENTORY_ORGS JIHO
1824: WHERE JIRP.LOCATION_ID = P_LOCATION_ID
1825: AND JIRP.ORGANIZATION_ID = P_ORGANIZATION_ID
1826: AND ABS(JIRP.VENDOR_ID) = JIHO.ORGANIZATION_ID
1827: AND ABS(JIRP.VENDOR_SITE_ID) = JIHO.LOCATION_ID

Line 1969: JAI_CMN_INVENTORY_ORGS JIHO

1965: ,0)
1966: ,0)) CREDIT_AVAILED_ON_INPUTS
1967: FROM
1968: JAI_CMN_RG_23AC_II_TRXS JIRP,
1969: JAI_CMN_INVENTORY_ORGS JIHO
1970: WHERE JIRP.LOCATION_ID = P_LOCATION_ID
1971: AND JIRP.ORGANIZATION_ID = P_ORGANIZATION_ID
1972: AND ABS(JIRP.VENDOR_ID) = JIHO.ORGANIZATION_ID
1973: AND ABS(JIRP.VENDOR_SITE_ID) = JIHO.LOCATION_ID

Line 2070: JAI_CMN_INVENTORY_ORGS JIHO

2066: ,0)
2067: FROM
2068: JAI_CMN_RG_OTHERS JRO,
2069: JAI_CMN_RG_23AC_II_TRXS RG23,
2070: JAI_CMN_INVENTORY_ORGS JIHO
2071: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2072: AND ABS(RG23.VENDOR_ID) = JIHO.ORGANIZATION_ID
2073: AND ABS(RG23.VENDOR_SITE_ID) = JIHO.LOCATION_ID
2074: AND JIHO.MANUFACTURING = 'Y'

Line 2143: JAI_CMN_INVENTORY_ORGS JIHO

2139: ,0)
2140: FROM
2141: JAI_CMN_RG_OTHERS JRO,
2142: JAI_CMN_RG_23AC_II_TRXS RG23,
2143: JAI_CMN_INVENTORY_ORGS JIHO
2144: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2145: AND ABS(RG23.VENDOR_ID) = JIHO.ORGANIZATION_ID
2146: AND ABS(RG23.VENDOR_SITE_ID) = JIHO.LOCATION_ID
2147: AND JIHO.TRADING = 'Y'

Line 2698: JAI_CMN_INVENTORY_ORGS JIHO

2694: ,0)
2695: FROM
2696: JAI_CMN_RG_OTHERS JRO,
2697: JAI_CMN_RG_23AC_II_TRXS RG23,
2698: JAI_CMN_INVENTORY_ORGS JIHO
2699: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2700: AND ABS(RG23.VENDOR_ID) = JIHO.ORGANIZATION_ID
2701: AND ABS(RG23.VENDOR_SITE_ID) = JIHO.LOCATION_ID
2702: AND JIHO.MANUFACTURING = 'Y'

Line 2771: JAI_CMN_INVENTORY_ORGS JIHO

2767: ,0)
2768: FROM
2769: JAI_CMN_RG_OTHERS JRO,
2770: JAI_CMN_RG_23AC_II_TRXS RG23,
2771: JAI_CMN_INVENTORY_ORGS JIHO
2772: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2773: AND ABS(RG23.VENDOR_ID) = JIHO.ORGANIZATION_ID
2774: AND ABS(RG23.VENDOR_SITE_ID) = JIHO.LOCATION_ID
2775: AND JIHO.TRADING = 'Y'