Financials for India - EBS (MOSC)

MOSC Banner

Need to derive hardware and software items lines. Not able to find software line in JAI_IRN_TABLE.

we are able to see only hardware item details..software item line is missing in the JAI_IRN_TABLE.
could you please help to find the right table to derive software and hardware items.
Developing GSTR1 Return Detail Report.

SELECT hsn_code, quantity, decode( uom, 'EA', 'PCS', '', 'PCS' ) uom, unit_price, cgst_rate, sgst_rate, igst_rate, cess_rate, state_cess_rate, cess_nonadv_amount, assessable_amount, cgst_amount, sgst_amount, igst_amount, cess_amount, state_cess_amount, state_cess_nonadvl_amt, nvl( other_charges, 0 ) othchrg, total_item_value, det_factor_id, discount FROM apps.jai_irn_details WHERE entity_code = ps_entity_code AND trx_id = pn_trx_id ORDER BY item_serial_number;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center