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_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 1017: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;

1013: v_order_invoice_type_up VARCHAR2(25);---ashish 10june
1014: v_register_code_up VARCHAR2(25);---ashish 10june
1015: v_errbuf VARCHAR2(250);
1016: -- added by sriram - bug # 3021588
1017: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
1018: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
1019: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
1020: -- added by sriram - bug # 3021588
1021: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;/*Bug#4601570 bduvarag*/

Line 1018: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;

1014: v_register_code_up VARCHAR2(25);---ashish 10june
1015: v_errbuf VARCHAR2(250);
1016: -- added by sriram - bug # 3021588
1017: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
1018: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
1019: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
1020: -- added by sriram - bug # 3021588
1021: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;/*Bug#4601570 bduvarag*/
1022: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;/*Bug#4601570 bduvarag*/

Line 1019: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;

1015: v_errbuf VARCHAR2(250);
1016: -- added by sriram - bug # 3021588
1017: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
1018: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
1019: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
1020: -- added by sriram - bug # 3021588
1021: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;/*Bug#4601570 bduvarag*/
1022: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;/*Bug#4601570 bduvarag*/
1023:

Line 1051: FROM JAI_OM_OE_BOND_REG_HDRS

1047: WHERE organization_id = p_org_id AND location_id = p_loc_id;
1048:
1049: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1050: SELECT register_code
1051: FROM JAI_OM_OE_BOND_REG_HDRS
1052: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
1053: register_id IN (SELECT register_id
1054: FROM JAI_OM_OE_BOND_REG_DTLS
1055: WHERE order_type_id = pr_new.batch_source_id AND order_flag= 'N'); /* Modified by Ramananda for removal of SQL LITERALs */

Line 1088: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

1084: CURSOR register_balance_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1085: SELECT NVL(register_balance,0) register_balance
1086: FROM JAI_OM_OE_BOND_TRXS
1087: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1088: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1089: WHERE A.register_id = B.register_id
1090: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
1091:
1092: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS

Line 1096: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

1092: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1093: SELECT NVL(rg23d_register_balance,0) rg23d_register_balance
1094: FROM JAI_OM_OE_BOND_TRXS
1095: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1096: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1097: WHERE A.register_id = B.register_id
1098: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
1099:
1100: CURSOR line_cur IS

Line 2482: FROM JAI_OM_OE_BOND_REG_HDRS

2478:
2479: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER,
2480: p_batch_source_id IN NUMBER) IS
2481: SELECT register_code
2482: FROM JAI_OM_OE_BOND_REG_HDRS
2483: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
2484: register_id IN (SELECT register_id
2485: FROM JAI_OM_OE_BOND_REG_DTLS
2486: WHERE order_type_id = p_batch_source_id AND order_flag = 'N');

Line 2497: FROM JAI_OM_OE_BOND_REG_HDRS A,

2493: CURSOR register_code_cur1(p_organization_id NUMBER,
2494: p_location_id NUMBER,
2495: p_order_type VARCHAR2) IS
2496: SELECT A.register_code
2497: FROM JAI_OM_OE_BOND_REG_HDRS A,
2498: JAI_OM_OE_BOND_REG_DTLS b,
2499: oe_transaction_types_tl ott
2500: WHERE A.organization_id = p_organization_id
2501: AND A.location_id = p_location_id