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

Line 88: FROM JAI_OM_OE_BOND_REG_HDRS

84:
85:
86: Cursor register_code_cur(p_org_id IN Number, p_loc_id IN Number) IS
87: SELECT register_code
88: FROM JAI_OM_OE_BOND_REG_HDRS
89: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
90: register_id in (SELECT register_id
91: FROM JAI_OM_OE_BOND_REG_DTLS
92: WHERE order_type_id = pr_new.batch_source_id and order_flag = 'N');

Line 1029: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;

1025: v_order_invoice_type_up VARCHAR2(25);---ashish 10june
1026: v_register_code_up VARCHAR2(25);---ashish 10june
1027: v_errbuf VARCHAR2(250);
1028: -- added by sriram - bug # 3021588
1029: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
1030: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
1031: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
1032: -- added by sriram - bug # 3021588
1033: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;/*Bug#4601570 bduvarag*/

Line 1030: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;

1026: v_register_code_up VARCHAR2(25);---ashish 10june
1027: v_errbuf VARCHAR2(250);
1028: -- added by sriram - bug # 3021588
1029: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
1030: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
1031: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
1032: -- added by sriram - bug # 3021588
1033: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;/*Bug#4601570 bduvarag*/
1034: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;/*Bug#4601570 bduvarag*/

Line 1031: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;

1027: v_errbuf VARCHAR2(250);
1028: -- added by sriram - bug # 3021588
1029: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
1030: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
1031: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
1032: -- added by sriram - bug # 3021588
1033: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;/*Bug#4601570 bduvarag*/
1034: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;/*Bug#4601570 bduvarag*/
1035:

Line 1063: FROM JAI_OM_OE_BOND_REG_HDRS

1059: WHERE organization_id = p_org_id AND location_id = p_loc_id;
1060:
1061: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1062: SELECT register_code
1063: FROM JAI_OM_OE_BOND_REG_HDRS
1064: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
1065: register_id IN (SELECT register_id
1066: FROM JAI_OM_OE_BOND_REG_DTLS
1067: WHERE order_type_id = pr_new.batch_source_id AND order_flag= 'N'); /* Modified by Ramananda for removal of SQL LITERALs */

Line 1100: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

1096: CURSOR register_balance_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1097: SELECT NVL(register_balance,0) register_balance
1098: FROM JAI_OM_OE_BOND_TRXS
1099: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1100: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1101: WHERE A.register_id = B.register_id
1102: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
1103:
1104: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS

Line 1108: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

1104: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1105: SELECT NVL(rg23d_register_balance,0) rg23d_register_balance
1106: FROM JAI_OM_OE_BOND_TRXS
1107: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1108: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1109: WHERE A.register_id = B.register_id
1110: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
1111:
1112: CURSOR line_cur IS

Line 2912: FROM JAI_OM_OE_BOND_REG_HDRS

2908:
2909: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER,
2910: p_batch_source_id IN NUMBER) IS
2911: SELECT register_code
2912: FROM JAI_OM_OE_BOND_REG_HDRS
2913: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
2914: register_id IN (SELECT register_id
2915: FROM JAI_OM_OE_BOND_REG_DTLS
2916: WHERE order_type_id = p_batch_source_id AND order_flag = 'N');

Line 2927: FROM JAI_OM_OE_BOND_REG_HDRS A,

2923: CURSOR register_code_cur1(p_organization_id NUMBER,
2924: p_location_id NUMBER,
2925: p_order_type VARCHAR2) IS
2926: SELECT A.register_code
2927: FROM JAI_OM_OE_BOND_REG_HDRS A,
2928: JAI_OM_OE_BOND_REG_DTLS b,
2929: oe_transaction_types_tl ott
2930: WHERE A.organization_id = p_organization_id
2931: AND A.location_id = p_location_id