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 252: JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

248: IS
249: SELECT
250: A.register_code
251: FROM
252: JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
253: WHERE
254: a.organization_id = p_organization_id AND
255: a.location_id = p_location_id AND
256: a.register_id = b.register_id AND

Line 1578: JAI_OM_OE_BOND_REG_HDRS a,

1574: ) IS
1575: SELECT
1576: a.register_code
1577: FROM
1578: JAI_OM_OE_BOND_REG_HDRS a,
1579: JAI_OM_OE_BOND_REG_DTLS b
1580: WHERE
1581: A.organization_id = p_organization_id AND
1582: A.location_id = p_location_id AND

Line 1625: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

1621: WHERE A.sub_inventory_name = p_subinventory
1622: AND A.organization_id = p_organization_id;
1623: CURSOR register_code_cur(p_organization_id NUMBER, p_location_id NUMBER, p_order_type_id NUMBER) IS
1624: SELECT A.register_code
1625: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
1626: WHERE A.organization_id = p_organization_id
1627: AND A.location_id = p_location_id
1628: AND A.register_id = b.register_id
1629: AND b.order_flag = 'Y'

Line 1661: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

1657: CURSOR register_balance_cur(p_organization_id NUMBER,p_location_id NUMBER) IS
1658: SELECT register_balance
1659: FROM JAI_OM_OE_BOND_TRXS
1660: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1661: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1662: WHERE A.register_id = B.register_id
1663: AND B.organization_id = p_organization_id
1664: AND B.location_id = p_location_id );
1665: CURSOR Get_Tax_Lines_Details_Cur1 IS

Line 1975: 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.

1971:
1972: For Multiple Bond Register Enhancement,
1973: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
1974: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
1975: 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.
1976:
1977: 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
1978:
1979: 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 1980: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the

1976:
1977: 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
1978:
1979: Provision for letter of undertaking has been incorporated. Letter of undetaking is also a type of bond register but without validation for the balances.
1980: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the
1981: associated register id , if yes , then validation is only based on bond expiry date .
1982:
1983: This fix has introduced huge dependency . All future changes in this object should have this bug as a prereq
1984: