APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_INV_ITM_SETUPS

Line 1075: FROM JAI_INV_ITM_SETUPS

1071: location_id = p_loc_id;
1072:
1073: CURSOR item_class_cur(P_ORG_ID IN NUMBER, P_Item_id IN NUMBER) IS
1074: SELECT item_class, excise_flag
1075: FROM JAI_INV_ITM_SETUPS
1076: WHERE inventory_item_id = P_Item_Id AND
1077: ORGANIZATION_ID = P_ORG_ID;
1078:
1079: CURSOR organization_cur IS

Line 1123: JAI_INV_ITM_SETUPS C

1119: b.stform_type,
1120: A.tax_line_no
1121: FROM JAI_AR_TRX_TAX_LINES A ,
1122: JAI_CMN_TAXES_ALL B,
1123: JAI_INV_ITM_SETUPS C
1124: WHERE link_to_cust_trx_line_id = p_line_id
1125: AND b.tax_type IN --('Excise','Addl. Excise','Other Excise') /* Modified by Ramananda for removal of SQL LITERALs */
1126: (jai_constants.tax_type_excise,jai_constants.tax_type_exc_additional,jai_constants.tax_type_exc_other)
1127: AND A.tax_id = b.tax_id

Line 1236: JAI_INV_ITM_SETUPS jmtl

1232: FROM JAI_AR_TRXS jtrx,
1233: JAI_AR_TRX_LINES jtl,
1234: JAI_AR_TRX_TAX_LINES jrtl,
1235: JAI_CMN_TAXES_ALL jtc ,
1236: JAI_INV_ITM_SETUPS jmtl
1237: WHERE jrtl.tax_id = jtc.tax_id
1238: AND jtrx.customer_trx_id = jtl.customer_Trx_id
1239: AND jrtl.link_to_cust_trx_line_id = jtl.customer_trx_line_id
1240: AND jtl.inventory_item_id = jmtl.inventory_item_id