APPS.JAI_AR_TRXS_PKG dependencies on JAI_INV_ITM_SETUPS

Line 158: JAI_INV_ITM_SETUPS C

154: b.tax_type t_type,
155: b.stform_type,
156: a.tax_line_no
157: from JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B,
158: JAI_INV_ITM_SETUPS C
159: where link_to_cust_trx_line_id = p_line_id
160: and a.tax_id = b.tax_id
161: and c.inventory_item_id = p_inventory_item_id
162: and c.organization_id = p_org_id

Line 167: from JAI_INV_ITM_SETUPS

163: AND c.item_class in ('RMIN','RMEX','CGEX','CGIN','CCEX','CCIN','FGIN','FGEX')
164: order by 1;
165: cursor item_class_cur(P_ORG_ID IN NUMBER,P_INVENTORY_ITEM_ID IN NUMBER) IS
166: select item_class, excise_flag,item_trading_flag
167: from JAI_INV_ITM_SETUPS
168: where inventory_item_id = p_inventory_item_id AND
169: ORGANIZATION_ID = P_ORG_ID;
170: cursor organization_cur IS
171: select organization_id,location_id