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 1116: cursor c_mtl_interorg_parameters

1112: from po_distributions_all
1113: where line_location_id = cp_po_line_location_id
1114: );
1115:
1116: cursor c_mtl_interorg_parameters
1117: (cp_from_organization_id number, cp_to_organization_id number) is
1118: select interorg_payables_account,
1119: intransit_inv_account,
1120: interorg_receivables_account,

Line 1123: from mtl_interorg_parameters

1119: intransit_inv_account,
1120: interorg_receivables_account,
1121: intransit_type,
1122: fob_point
1123: from mtl_interorg_parameters
1124: where from_organization_id = cp_from_organization_id
1125: and to_organization_id = cp_to_organization_id;
1126:
1127: cursor c_iso_from_org_type(cp_organization_id number) is

Line 1140: r_mtl_interorg_parameters c_mtl_interorg_parameters%rowtype;

1136: r_mtl_parameters c_mtl_parameters%rowtype;
1137: r_po_distributions_all c_po_distributions_all%rowtype;
1138: r_po_distributions_all_1 c_po_distributions_all_1%rowtype;
1139: r_rcv_parameters c_rcv_parameters%rowtype;
1140: r_mtl_interorg_parameters c_mtl_interorg_parameters%rowtype;
1141: r_iso_from_org_type c_iso_from_org_type%rowtype; /* Bug#4171469 */
1142:
1143: begin
1144:

Line 1243: open c_mtl_interorg_parameters(p_from_organization_id, p_to_organization_id);

1239: p_trading_to_trading_iso := 'N';
1240: if p_receipt_source_code in('INTERNAL ORDER','INVENTORY')then -- bug 6030615
1241:
1242: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); /* 14 */
1243: open c_mtl_interorg_parameters(p_from_organization_id, p_to_organization_id);
1244: fetch c_mtl_interorg_parameters into r_mtl_interorg_parameters;
1245: close c_mtl_interorg_parameters;
1246:
1247: /* Bug#4171469 */

Line 1244: fetch c_mtl_interorg_parameters into r_mtl_interorg_parameters;

1240: if p_receipt_source_code in('INTERNAL ORDER','INVENTORY')then -- bug 6030615
1241:
1242: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); /* 14 */
1243: open c_mtl_interorg_parameters(p_from_organization_id, p_to_organization_id);
1244: fetch c_mtl_interorg_parameters into r_mtl_interorg_parameters;
1245: close c_mtl_interorg_parameters;
1246:
1247: /* Bug#4171469 */
1248: open c_iso_from_org_type(p_from_organization_id);

Line 1245: close c_mtl_interorg_parameters;

1241:
1242: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); /* 14 */
1243: open c_mtl_interorg_parameters(p_from_organization_id, p_to_organization_id);
1244: fetch c_mtl_interorg_parameters into r_mtl_interorg_parameters;
1245: close c_mtl_interorg_parameters;
1246:
1247: /* Bug#4171469 */
1248: open c_iso_from_org_type(p_from_organization_id);
1249: fetch c_iso_from_org_type into r_iso_from_org_type;

Line 1270: p_interorg_payables_account := r_mtl_interorg_parameters.interorg_payables_account;

1266:
1267: end if;
1268:
1269: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
1270: p_interorg_payables_account := r_mtl_interorg_parameters.interorg_payables_account;
1271: p_intransit_inv_account := r_mtl_interorg_parameters.intransit_inv_account;
1272: p_interorg_receivables_account := r_mtl_interorg_parameters.interorg_receivables_account;
1273: p_intransit_type := r_mtl_interorg_parameters.intransit_type;
1274: p_fob_point := r_mtl_interorg_parameters.fob_point;

Line 1271: p_intransit_inv_account := r_mtl_interorg_parameters.intransit_inv_account;

1267: end if;
1268:
1269: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
1270: p_interorg_payables_account := r_mtl_interorg_parameters.interorg_payables_account;
1271: p_intransit_inv_account := r_mtl_interorg_parameters.intransit_inv_account;
1272: p_interorg_receivables_account := r_mtl_interorg_parameters.interorg_receivables_account;
1273: p_intransit_type := r_mtl_interorg_parameters.intransit_type;
1274: p_fob_point := r_mtl_interorg_parameters.fob_point;
1275:

Line 1272: p_interorg_receivables_account := r_mtl_interorg_parameters.interorg_receivables_account;

1268:
1269: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
1270: p_interorg_payables_account := r_mtl_interorg_parameters.interorg_payables_account;
1271: p_intransit_inv_account := r_mtl_interorg_parameters.intransit_inv_account;
1272: p_interorg_receivables_account := r_mtl_interorg_parameters.interorg_receivables_account;
1273: p_intransit_type := r_mtl_interorg_parameters.intransit_type;
1274: p_fob_point := r_mtl_interorg_parameters.fob_point;
1275:
1276: end if; /*p_receipt_source_code = 'INTERNAL ORDER'*/

Line 1273: p_intransit_type := r_mtl_interorg_parameters.intransit_type;

1269: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
1270: p_interorg_payables_account := r_mtl_interorg_parameters.interorg_payables_account;
1271: p_intransit_inv_account := r_mtl_interorg_parameters.intransit_inv_account;
1272: p_interorg_receivables_account := r_mtl_interorg_parameters.interorg_receivables_account;
1273: p_intransit_type := r_mtl_interorg_parameters.intransit_type;
1274: p_fob_point := r_mtl_interorg_parameters.fob_point;
1275:
1276: end if; /*p_receipt_source_code = 'INTERNAL ORDER'*/
1277:

Line 1274: p_fob_point := r_mtl_interorg_parameters.fob_point;

1270: p_interorg_payables_account := r_mtl_interorg_parameters.interorg_payables_account;
1271: p_intransit_inv_account := r_mtl_interorg_parameters.intransit_inv_account;
1272: p_interorg_receivables_account := r_mtl_interorg_parameters.interorg_receivables_account;
1273: p_intransit_type := r_mtl_interorg_parameters.intransit_type;
1274: p_fob_point := r_mtl_interorg_parameters.fob_point;
1275:
1276: end if; /*p_receipt_source_code = 'INTERNAL ORDER'*/
1277:
1278:

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

1874: if p_intransit_inv_account is null then
1875:
1876: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
1877: p_process_flag := 'E';
1878: p_process_message := 'Intransit Inventory Account is not defined in mtl_interorg_parameters for ' ||
1879: 'from and to organization of the ISO. ';
1880: goto exit_from_procedure;
1881: else
1882: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */

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

1889:
1890: if p_interorg_payables_account is null then
1891: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
1892: p_process_flag := 'E';
1893: p_process_message := 'Inter-org Payables Account is not defined in mtl_interorg_parameters for ' ||
1894: 'from and to organization of the ISO. ';
1895: goto exit_from_procedure;
1896: else
1897: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */