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

Line 1756: from JAI_CMN_BOE_MATCHINGS

1752: is
1753:
1754: cursor c_is_boe_applied(cp_shipment_line_id number, cp_parent_transaction_id number) is
1755: select count(boe_id)
1756: from JAI_CMN_BOE_MATCHINGS
1757: where shipment_line_id = cp_shipment_line_id
1758: and transaction_id = cp_parent_transaction_id;
1759:
1760: ln_boe_count number; -- :=0 File.Sql.35 by Brathod

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

1956: if nvl(p_simulation , 'Y') <> 'Y' then
1957:
1958: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
1959:
1960: /* Insert a apply record in JAI_CMN_BOE_MATCHINGS */
1961: insert into JAI_CMN_BOE_MATCHINGS
1962: (BOE_MATCHING_ID,
1963: transaction_id,
1964: shipment_header_id,

Line 1961: insert into JAI_CMN_BOE_MATCHINGS

1957:
1958: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
1959:
1960: /* Insert a apply record in JAI_CMN_BOE_MATCHINGS */
1961: insert into JAI_CMN_BOE_MATCHINGS
1962: (BOE_MATCHING_ID,
1963: transaction_id,
1964: shipment_header_id,
1965: shipment_line_id,

Line 1974: ( JAI_CMN_BOE_MATCHINGS_S.nextval,

1970: last_update_date,
1971: last_updated_by
1972: )
1973: values
1974: ( JAI_CMN_BOE_MATCHINGS_S.nextval,
1975: p_transaction_id,
1976: p_shipment_header_id,
1977: p_shipment_line_id,
1978: cur_available_boe.boe_id,

Line 2060: from JAI_CMN_BOE_MATCHINGS

2056: is
2057:
2058: cursor c_ja_in_rcp_boe(cp_shipment_line_id number, cp_transaction_id number) is
2059: select boe_id, amount
2060: from JAI_CMN_BOE_MATCHINGS
2061: where shipment_line_id = cp_shipment_line_id
2062: and transaction_id = cp_transaction_id;
2063:
2064: ln_bal_boe_amount number;

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

2089: ln_boe_amount_to_unapply := ln_bal_boe_amount;
2090: end if;
2091:
2092: if nvl(p_simulation , 'Y') <> 'Y' then
2093: /* Insert a unapply record in JAI_CMN_BOE_MATCHINGS */
2094: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
2095: insert into JAI_CMN_BOE_MATCHINGS
2096: (BOE_MATCHING_ID,
2097: transaction_id,

Line 2095: insert into JAI_CMN_BOE_MATCHINGS

2091:
2092: if nvl(p_simulation , 'Y') <> 'Y' then
2093: /* Insert a unapply record in JAI_CMN_BOE_MATCHINGS */
2094: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
2095: insert into JAI_CMN_BOE_MATCHINGS
2096: (BOE_MATCHING_ID,
2097: transaction_id,
2098: shipment_header_id,
2099: shipment_line_id,

Line 2108: ( JAI_CMN_BOE_MATCHINGS_S.nextval,

2104: last_update_date,
2105: last_updated_by
2106: )
2107: values
2108: ( JAI_CMN_BOE_MATCHINGS_S.nextval,
2109: p_transaction_id,
2110: p_shipment_header_id,
2111: p_shipment_line_id,
2112: applied_boe_rec.boe_id,