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 MTL_INTERORG_PARAMETERS

Line 973: cursor c_mtl_interorg_parameters

969: from po_distributions_all
970: where line_location_id = cp_po_line_location_id
971: );
972:
973: cursor c_mtl_interorg_parameters
974: (cp_from_organization_id number, cp_to_organization_id number) is
975: select interorg_payables_account,
976: intransit_inv_account,
977: interorg_receivables_account,

Line 980: from mtl_interorg_parameters

976: intransit_inv_account,
977: interorg_receivables_account,
978: intransit_type,
979: fob_point
980: from mtl_interorg_parameters
981: where from_organization_id = cp_from_organization_id
982: and to_organization_id = cp_to_organization_id;
983:
984: cursor c_iso_from_org_type(cp_organization_id number) is

Line 997: r_mtl_interorg_parameters c_mtl_interorg_parameters%rowtype;

993: r_mtl_parameters c_mtl_parameters%rowtype;
994: r_po_distributions_all c_po_distributions_all%rowtype;
995: r_po_distributions_all_1 c_po_distributions_all_1%rowtype;
996: r_rcv_parameters c_rcv_parameters%rowtype;
997: r_mtl_interorg_parameters c_mtl_interorg_parameters%rowtype;
998: r_iso_from_org_type c_iso_from_org_type%rowtype; /* Bug#4171469 */
999:
1000: begin
1001:

Line 1100: open c_mtl_interorg_parameters(p_from_organization_id, p_to_organization_id);

1096: p_trading_to_trading_iso := 'N';
1097: if p_receipt_source_code in('INTERNAL ORDER','INVENTORY')then -- bug 6030615
1098:
1099: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); /* 14 */
1100: open c_mtl_interorg_parameters(p_from_organization_id, p_to_organization_id);
1101: fetch c_mtl_interorg_parameters into r_mtl_interorg_parameters;
1102: close c_mtl_interorg_parameters;
1103:
1104: /* Bug#4171469 */

Line 1101: fetch c_mtl_interorg_parameters into r_mtl_interorg_parameters;

1097: if p_receipt_source_code in('INTERNAL ORDER','INVENTORY')then -- bug 6030615
1098:
1099: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); /* 14 */
1100: open c_mtl_interorg_parameters(p_from_organization_id, p_to_organization_id);
1101: fetch c_mtl_interorg_parameters into r_mtl_interorg_parameters;
1102: close c_mtl_interorg_parameters;
1103:
1104: /* Bug#4171469 */
1105: open c_iso_from_org_type(p_from_organization_id);

Line 1102: close c_mtl_interorg_parameters;

1098:
1099: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); /* 14 */
1100: open c_mtl_interorg_parameters(p_from_organization_id, p_to_organization_id);
1101: fetch c_mtl_interorg_parameters into r_mtl_interorg_parameters;
1102: close c_mtl_interorg_parameters;
1103:
1104: /* Bug#4171469 */
1105: open c_iso_from_org_type(p_from_organization_id);
1106: fetch c_iso_from_org_type into r_iso_from_org_type;

Line 1127: p_interorg_payables_account := r_mtl_interorg_parameters.interorg_payables_account;

1123:
1124: end if;
1125:
1126: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
1127: p_interorg_payables_account := r_mtl_interorg_parameters.interorg_payables_account;
1128: p_intransit_inv_account := r_mtl_interorg_parameters.intransit_inv_account;
1129: p_interorg_receivables_account := r_mtl_interorg_parameters.interorg_receivables_account;
1130: p_intransit_type := r_mtl_interorg_parameters.intransit_type;
1131: p_fob_point := r_mtl_interorg_parameters.fob_point;

Line 1128: p_intransit_inv_account := r_mtl_interorg_parameters.intransit_inv_account;

1124: end if;
1125:
1126: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
1127: p_interorg_payables_account := r_mtl_interorg_parameters.interorg_payables_account;
1128: p_intransit_inv_account := r_mtl_interorg_parameters.intransit_inv_account;
1129: p_interorg_receivables_account := r_mtl_interorg_parameters.interorg_receivables_account;
1130: p_intransit_type := r_mtl_interorg_parameters.intransit_type;
1131: p_fob_point := r_mtl_interorg_parameters.fob_point;
1132:

Line 1129: p_interorg_receivables_account := r_mtl_interorg_parameters.interorg_receivables_account;

1125:
1126: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
1127: p_interorg_payables_account := r_mtl_interorg_parameters.interorg_payables_account;
1128: p_intransit_inv_account := r_mtl_interorg_parameters.intransit_inv_account;
1129: p_interorg_receivables_account := r_mtl_interorg_parameters.interorg_receivables_account;
1130: p_intransit_type := r_mtl_interorg_parameters.intransit_type;
1131: p_fob_point := r_mtl_interorg_parameters.fob_point;
1132:
1133: end if; /*p_receipt_source_code = 'INTERNAL ORDER'*/

Line 1130: p_intransit_type := r_mtl_interorg_parameters.intransit_type;

1126: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
1127: p_interorg_payables_account := r_mtl_interorg_parameters.interorg_payables_account;
1128: p_intransit_inv_account := r_mtl_interorg_parameters.intransit_inv_account;
1129: p_interorg_receivables_account := r_mtl_interorg_parameters.interorg_receivables_account;
1130: p_intransit_type := r_mtl_interorg_parameters.intransit_type;
1131: p_fob_point := r_mtl_interorg_parameters.fob_point;
1132:
1133: end if; /*p_receipt_source_code = 'INTERNAL ORDER'*/
1134:

Line 1131: p_fob_point := r_mtl_interorg_parameters.fob_point;

1127: p_interorg_payables_account := r_mtl_interorg_parameters.interorg_payables_account;
1128: p_intransit_inv_account := r_mtl_interorg_parameters.intransit_inv_account;
1129: p_interorg_receivables_account := r_mtl_interorg_parameters.interorg_receivables_account;
1130: p_intransit_type := r_mtl_interorg_parameters.intransit_type;
1131: p_fob_point := r_mtl_interorg_parameters.fob_point;
1132:
1133: end if; /*p_receipt_source_code = 'INTERNAL ORDER'*/
1134:
1135:

Line 1579: p_process_message := 'Intransit Inventory Account is not defined in mtl_interorg_parameters for ' ||

1575: if p_intransit_inv_account is null then
1576:
1577: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
1578: p_process_flag := 'E';
1579: p_process_message := 'Intransit Inventory Account is not defined in mtl_interorg_parameters for ' ||
1580: 'from and to organization of the ISO. ';
1581: goto exit_from_procedure;
1582: else
1583: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */

Line 1594: p_process_message := 'Inter-org Payables Account is not defined in mtl_interorg_parameters for ' ||

1590:
1591: if p_interorg_payables_account is null then
1592: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
1593: p_process_flag := 'E';
1594: p_process_message := 'Inter-org Payables Account is not defined in mtl_interorg_parameters for ' ||
1595: 'from and to organization of the ISO. ';
1596: goto exit_from_procedure;
1597: else
1598: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */