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.GMI_SHIPPING_UTIL dependencies on MTL_INTERORG_PARAMETERS

Line 2366: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER , c_to_organization_id NUMBER) IS

2362: From mtl_system_items
2363: Where inventory_item_id = p_shipping_line.inventory_item_id
2364: and organization_id = p_shipping_line.organization_id;
2365:
2366: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER , c_to_organization_id NUMBER) IS
2367: SELECT intransit_type
2368: FROM mtl_interorg_parameters
2369: WHERE from_organization_id = c_from_organization_id AND
2370: to_organization_id = c_to_organization_id;

Line 2368: FROM mtl_interorg_parameters

2364: and organization_id = p_shipping_line.organization_id;
2365:
2366: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER , c_to_organization_id NUMBER) IS
2367: SELECT intransit_type
2368: FROM mtl_interorg_parameters
2369: WHERE from_organization_id = c_from_organization_id AND
2370: to_organization_id = c_to_organization_id;
2371:
2372: Cursor get_default_loct (p_org_id number) IS

Line 2454: /* Bug 2137423, check mtl_interorg_parameters to decide transaction codes */

2450: l_trx_source_type_id := 8;
2451: l_trx_action_id := 2;
2452: l_trx_type_code := 50 /* Subinv_xfer */;
2453: ELSIF (l_po_info.destination_organization_id <> l_po_info.source_organization_id) THEN
2454: /* Bug 2137423, check mtl_interorg_parameters to decide transaction codes */
2455: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
2456: l_po_info.destination_organization_id);
2457: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
2458: IF c_mtl_interorg_parameters%NOTFOUND THEN

Line 2455: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,

2451: l_trx_action_id := 2;
2452: l_trx_type_code := 50 /* Subinv_xfer */;
2453: ELSIF (l_po_info.destination_organization_id <> l_po_info.source_organization_id) THEN
2454: /* Bug 2137423, check mtl_interorg_parameters to decide transaction codes */
2455: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
2456: l_po_info.destination_organization_id);
2457: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
2458: IF c_mtl_interorg_parameters%NOTFOUND THEN
2459: /* default to intransit */

Line 2457: FETCH c_mtl_interorg_parameters INTO l_intransit_type;

2453: ELSIF (l_po_info.destination_organization_id <> l_po_info.source_organization_id) THEN
2454: /* Bug 2137423, check mtl_interorg_parameters to decide transaction codes */
2455: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
2456: l_po_info.destination_organization_id);
2457: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
2458: IF c_mtl_interorg_parameters%NOTFOUND THEN
2459: /* default to intransit */
2460: GMI_RESERVATION_UTIL.println('In transit shipment');
2461: l_trx_source_type_id := 8;

Line 2458: IF c_mtl_interorg_parameters%NOTFOUND THEN

2454: /* Bug 2137423, check mtl_interorg_parameters to decide transaction codes */
2455: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
2456: l_po_info.destination_organization_id);
2457: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
2458: IF c_mtl_interorg_parameters%NOTFOUND THEN
2459: /* default to intransit */
2460: GMI_RESERVATION_UTIL.println('In transit shipment');
2461: l_trx_source_type_id := 8;
2462: l_trx_action_id := 21;

Line 2477: CLOSE c_mtl_interorg_parameters;

2473: l_trx_action_id := 21;
2474: l_trx_type_code := 62; /* intransit_shpmnt */
2475: END IF;
2476: END IF;
2477: CLOSE c_mtl_interorg_parameters;
2478: END IF;
2479: --If for direct receipt then
2480: IF l_trx_action_id = 3 THEN
2481: --check if item is location controlled