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_AR_TRX_HEADERS_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

Line 86: FROM JAI_OM_OE_BOND_REG_HDRS

82: SELECT organization_id, location_id FROM JAI_AR_TRX_APPS_RELS_T;
83:
84: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
85: SELECT register_code
86: FROM JAI_OM_OE_BOND_REG_HDRS
87: WHERE organization_id = p_org_id
88: AND location_id = p_loc_id
89: AND register_id in (SELECT register_id
90: FROM JAI_OM_OE_BOND_REG_DTLS

Line 1849: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;

1845: v_trans_type_up VARCHAR2(3);
1846: v_order_invoice_type_up VARCHAR2(25);
1847: v_register_code_up VARCHAR2(25);
1848: v_errbuf VARCHAR2(250);
1849: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
1850: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
1851: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
1852: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1853: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;

Line 1850: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;

1846: v_order_invoice_type_up VARCHAR2(25);
1847: v_register_code_up VARCHAR2(25);
1848: v_errbuf VARCHAR2(250);
1849: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
1850: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
1851: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
1852: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1853: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;
1854:

Line 1851: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;

1847: v_register_code_up VARCHAR2(25);
1848: v_errbuf VARCHAR2(250);
1849: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
1850: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
1851: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
1852: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1853: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;
1854:
1855: CURSOR complete_cur IS

Line 1881: FROM JAI_OM_OE_BOND_REG_HDRS

1877: AND location_id = p_loc_id;
1878:
1879: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1880: SELECT register_code
1881: FROM JAI_OM_OE_BOND_REG_HDRS
1882: WHERE organization_id = p_org_id
1883: AND location_id = p_loc_id
1884: AND register_id IN (SELECT register_id
1885: FROM JAI_OM_OE_BOND_REG_DTLS

Line 1922: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

1918: SELECT NVL(register_balance, 0) register_balance
1919: FROM JAI_OM_OE_BOND_TRXS
1920: WHERE transaction_id =
1921: (SELECT MAX(A.transaction_id)
1922: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1923: WHERE A.register_id = B.register_id
1924: AND B.organization_id = p_org_id
1925: AND B.location_id = p_loc_id);
1926:

Line 1932: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

1928: SELECT NVL(rg23d_register_balance, 0) rg23d_register_balance
1929: FROM JAI_OM_OE_BOND_TRXS
1930: WHERE transaction_id =
1931: (SELECT MAX(A.transaction_id)
1932: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1933: WHERE A.register_id = B.register_id
1934: AND B.organization_id = p_org_id
1935: AND B.location_id = p_loc_id);
1936: