APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on JAI_INV_ITM_SETUPS

Line 693: FROM JAI_INV_ITM_SETUPS

689: location_id = p_loc_id;
690:
691: CURSOR item_class_cur(P_ORG_ID IN NUMBER, P_Item_id IN NUMBER) IS
692: SELECT item_class, excise_flag
693: FROM JAI_INV_ITM_SETUPS
694: WHERE inventory_item_id = P_Item_Id AND
695: ORGANIZATION_ID = P_ORG_ID;
696:
697: CURSOR organization_cur IS

Line 741: JAI_INV_ITM_SETUPS C

737: b.stform_type,
738: A.tax_line_no
739: FROM JAI_AR_TRX_TAX_LINES A ,
740: JAI_CMN_TAXES_ALL B,
741: JAI_INV_ITM_SETUPS C
742: WHERE link_to_cust_trx_line_id = p_line_id
743: AND b.tax_type IN --('Excise','Addl. Excise','Other Excise')
744: (jai_constants.tax_type_excise,jai_constants.tax_type_exc_additional,jai_constants.tax_type_exc_other)
745: AND A.tax_id = b.tax_id

Line 849: JAI_INV_ITM_SETUPS jmtl

845: FROM JAI_AR_TRXS jtrx,
846: JAI_AR_TRX_LINES jtl,
847: JAI_AR_TRX_TAX_LINES jrtl,
848: JAI_CMN_TAXES_ALL jtc ,
849: JAI_INV_ITM_SETUPS jmtl
850: WHERE jrtl.tax_id = jtc.tax_id
851: AND jtrx.customer_trx_id = jtl.customer_Trx_id
852: AND jrtl.link_to_cust_trx_line_id = jtl.customer_trx_line_id
853: AND jtl.inventory_item_id = jmtl.inventory_item_id