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.

APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

Line 230: JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

226: IS
227: SELECT
228: A.register_code
229: FROM
230: JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
231: WHERE
232: a.organization_id = p_organization_id AND
233: a.location_id = p_location_id AND
234: a.register_id = b.register_id AND

Line 1338: JAI_OM_OE_BOND_REG_HDRS a,

1334: ) IS
1335: SELECT
1336: a.register_code
1337: FROM
1338: JAI_OM_OE_BOND_REG_HDRS a,
1339: JAI_OM_OE_BOND_REG_DTLS b
1340: WHERE
1341: A.organization_id = p_organization_id AND
1342: A.location_id = p_location_id AND

Line 1385: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

1381: WHERE A.sub_inventory_name = p_subinventory
1382: AND A.organization_id = p_organization_id;
1383: CURSOR register_code_cur(p_organization_id NUMBER, p_location_id NUMBER, p_order_type_id NUMBER) IS
1384: SELECT A.register_code
1385: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
1386: WHERE A.organization_id = p_organization_id
1387: AND A.location_id = p_location_id
1388: AND A.register_id = b.register_id
1389: AND b.order_flag = 'Y'

Line 1421: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

1417: CURSOR register_balance_cur(p_organization_id NUMBER,p_location_id NUMBER) IS
1418: SELECT register_balance
1419: FROM JAI_OM_OE_BOND_TRXS
1420: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1421: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1422: WHERE A.register_id = B.register_id
1423: AND B.organization_id = p_organization_id
1424: AND B.location_id = p_location_id );
1425: CURSOR Get_Tax_Lines_Details_Cur1 IS

Line 1735: introduction of 3 new columns in the JAI_OM_OE_BOND_REG_HDRS table and also call to the new package jai_cmn_bond_register_pkg.

1731:
1732: For Multiple Bond Register Enhancement,
1733: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
1734: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1735: introduction of 3 new columns in the JAI_OM_OE_BOND_REG_HDRS table and also call to the new package jai_cmn_bond_register_pkg.
1736:
1737: New Validations for checking the bond expiry date and to check the balance based on the call to the jai_cmn_bond_register_pkg has been added
1738:
1739: Provision for letter of undertaking has been incorporated. Letter of undetaking is also a type of bond register but without validation for the balances.

Line 1740: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the

1736:
1737: New Validations for checking the bond expiry date and to check the balance based on the call to the jai_cmn_bond_register_pkg has been added
1738:
1739: Provision for letter of undertaking has been incorporated. Letter of undetaking is also a type of bond register but without validation for the balances.
1740: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the
1741: associated register id , if yes , then validation is only based on bond expiry date .
1742:
1743: This fix has introduced huge dependency . All future changes in this object should have this bug as a prereq
1744: