eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_CMN_RG_EXC_INV_NOS

Line 1167: FROM JAI_CMN_RG_EXC_INV_NOS

1163:
1164: CURSOR Def_Excise_Invoice_Cur(p_organization_id IN NUMBER, p_location_id IN NUMBER, p_fin_year IN NUMBER,
1165: p_batch_name IN VARCHAR2, p_register_code IN VARCHAR2) IS
1166: SELECT start_number, end_number, jump_by, prefix
1167: FROM JAI_CMN_RG_EXC_INV_NOS
1168: WHERE organization_id = p_organization_id
1169: AND location_id = p_location_id
1170: AND fin_year = p_fin_year
1171: AND transaction_type IN ( 'I','DOM','EXP') --ashish 20jun02

Line 1177: FROM JAI_CMN_RG_EXC_INV_NOS

1173: AND register_code = p_register_code ; /* Modified by Ramananda for removal of SQL LITERALs */
1174:
1175: CURSOR excise_invoice_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER, p_fin_year IN NUMBER) IS
1176: SELECT NVL(MAX(GP1),0),NVL(MAX(GP2),0)
1177: FROM JAI_CMN_RG_EXC_INV_NOS
1178: WHERE organization_id = p_org_id
1179: AND location_id = p_loc_id
1180: AND fin_year = p_fin_year
1181: AND transaction_type IS NULL