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.

[Home] [Help]

APPS.JAI_AR_TRX_HEADERS_PKG dependencies on JAI_INV_ITM_SETUPS

Line 1908: FROM JAI_INV_ITM_SETUPS

1904: AND location_id = p_loc_id;
1905:
1906: CURSOR item_class_cur(P_ORG_ID IN NUMBER, P_Item_id IN NUMBER) IS
1907: SELECT item_class, excise_flag
1908: FROM JAI_INV_ITM_SETUPS
1909: WHERE inventory_item_id = P_Item_Id
1910: AND ORGANIZATION_ID = P_ORG_ID;
1911:
1912: CURSOR organization_cur IS

Line 1965: JAI_INV_ITM_SETUPS C

1961: b.stform_type,
1962: A.tax_line_no
1963: FROM JAI_AR_TRX_TAX_LINES A,
1964: JAI_CMN_TAXES_ALL B,
1965: JAI_INV_ITM_SETUPS C
1966: WHERE link_to_cust_trx_line_id = p_line_id
1967: AND b.tax_type IN (jai_constants.tax_type_excise,
1968: jai_constants.tax_type_exc_additional,
1969: jai_constants.tax_type_exc_other)

Line 2071: JAI_INV_ITM_SETUPS jmtl

2067: FROM JAI_AR_TRXS jtrx,
2068: JAI_AR_TRX_LINES jtl,
2069: JAI_AR_TRX_TAX_LINES jrtl,
2070: JAI_CMN_TAXES_ALL jtc,
2071: JAI_INV_ITM_SETUPS jmtl
2072: WHERE jrtl.tax_id = jtc.tax_id
2073: AND jtrx.customer_trx_id = jtl.customer_Trx_id
2074: AND jrtl.link_to_cust_trx_line_id = jtl.customer_trx_line_id
2075: AND jtl.inventory_item_id = jmtl.inventory_item_id