APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_INV_ITM_SETUPS

Line 1087: FROM JAI_INV_ITM_SETUPS

1083: location_id = p_loc_id;
1084:
1085: CURSOR item_class_cur(P_ORG_ID IN NUMBER, P_Item_id IN NUMBER) IS
1086: SELECT item_class, excise_flag
1087: FROM JAI_INV_ITM_SETUPS
1088: WHERE inventory_item_id = P_Item_Id AND
1089: ORGANIZATION_ID = P_ORG_ID;
1090:
1091: CURSOR organization_cur IS

Line 1135: JAI_INV_ITM_SETUPS C

1131: b.stform_type,
1132: A.tax_line_no
1133: FROM JAI_AR_TRX_TAX_LINES A ,
1134: JAI_CMN_TAXES_ALL B,
1135: JAI_INV_ITM_SETUPS C
1136: WHERE link_to_cust_trx_line_id = p_line_id
1137: AND b.tax_type IN --('Excise','Addl. Excise','Other Excise') /* Modified by Ramananda for removal of SQL LITERALs */
1138: (jai_constants.tax_type_excise,jai_constants.tax_type_exc_additional,jai_constants.tax_type_exc_other)
1139: AND A.tax_id = b.tax_id

Line 1248: JAI_INV_ITM_SETUPS jmtl

1244: FROM JAI_AR_TRXS jtrx,
1245: JAI_AR_TRX_LINES jtl,
1246: JAI_AR_TRX_TAX_LINES jrtl,
1247: JAI_CMN_TAXES_ALL jtc ,
1248: JAI_INV_ITM_SETUPS jmtl
1249: WHERE jrtl.tax_id = jtc.tax_id
1250: AND jtrx.customer_trx_id = jtl.customer_Trx_id
1251: AND jrtl.link_to_cust_trx_line_id = jtl.customer_trx_line_id
1252: AND jtl.inventory_item_id = jmtl.inventory_item_id