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_RCV_RCV_RTV_PKG dependencies on JAI_CMN_BOE_MATCHINGS

Line 2066: from JAI_CMN_BOE_MATCHINGS

2062: is
2063:
2064: cursor c_is_boe_applied(cp_shipment_line_id number, cp_parent_transaction_id number) is
2065: select count(boe_id)
2066: from JAI_CMN_BOE_MATCHINGS
2067: where shipment_line_id = cp_shipment_line_id
2068: and transaction_id = cp_parent_transaction_id;
2069:
2070: ln_boe_count number; -- :=0 File.Sql.35 by Brathod

Line 2288: /* Insert a apply record in JAI_CMN_BOE_MATCHINGS */

2284: if nvl(p_simulation , 'Y') <> 'Y' then
2285:
2286: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
2287:
2288: /* Insert a apply record in JAI_CMN_BOE_MATCHINGS */
2289: insert into JAI_CMN_BOE_MATCHINGS
2290: (BOE_MATCHING_ID,
2291: transaction_id,
2292: shipment_header_id,

Line 2289: insert into JAI_CMN_BOE_MATCHINGS

2285:
2286: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
2287:
2288: /* Insert a apply record in JAI_CMN_BOE_MATCHINGS */
2289: insert into JAI_CMN_BOE_MATCHINGS
2290: (BOE_MATCHING_ID,
2291: transaction_id,
2292: shipment_header_id,
2293: shipment_line_id,

Line 2302: ( JAI_CMN_BOE_MATCHINGS_S.nextval,

2298: last_update_date,
2299: last_updated_by
2300: )
2301: values
2302: ( JAI_CMN_BOE_MATCHINGS_S.nextval,
2303: p_transaction_id,
2304: p_shipment_header_id,
2305: p_shipment_line_id,
2306: cur_available_boe.boe_id,

Line 2388: from JAI_CMN_BOE_MATCHINGS

2384: is
2385:
2386: cursor c_ja_in_rcp_boe(cp_shipment_line_id number, cp_transaction_id number) is
2387: select boe_id, amount
2388: from JAI_CMN_BOE_MATCHINGS
2389: where shipment_line_id = cp_shipment_line_id
2390: and transaction_id = cp_transaction_id;
2391:
2392: ln_bal_boe_amount number;

Line 2421: /* Insert a unapply record in JAI_CMN_BOE_MATCHINGS */

2417: ln_boe_amount_to_unapply := ln_bal_boe_amount;
2418: end if;
2419:
2420: if nvl(p_simulation , 'Y') <> 'Y' then
2421: /* Insert a unapply record in JAI_CMN_BOE_MATCHINGS */
2422: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
2423: insert into JAI_CMN_BOE_MATCHINGS
2424: (BOE_MATCHING_ID,
2425: transaction_id,

Line 2423: insert into JAI_CMN_BOE_MATCHINGS

2419:
2420: if nvl(p_simulation , 'Y') <> 'Y' then
2421: /* Insert a unapply record in JAI_CMN_BOE_MATCHINGS */
2422: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
2423: insert into JAI_CMN_BOE_MATCHINGS
2424: (BOE_MATCHING_ID,
2425: transaction_id,
2426: shipment_header_id,
2427: shipment_line_id,

Line 2436: ( JAI_CMN_BOE_MATCHINGS_S.nextval,

2432: last_update_date,
2433: last_updated_by
2434: )
2435: values
2436: ( JAI_CMN_BOE_MATCHINGS_S.nextval,
2437: p_transaction_id,
2438: p_shipment_header_id,
2439: p_shipment_line_id,
2440: applied_boe_rec.boe_id,