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

Line 2508: /* Bug 2137423: checking MTL_INTERORG_PARAMETERS to internal transaction type */

2504: AND pl.requisition_line_id = pd.requisition_line_id;
2505: l_po_info c_po_info%ROWTYPE;
2506:
2507:
2508: /* Bug 2137423: checking MTL_INTERORG_PARAMETERS to internal transaction type */
2509: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER , c_to_organization_id NUMBER) IS
2510: SELECT intransit_type
2511: FROM mtl_interorg_parameters
2512: WHERE from_organization_id = c_from_organization_id AND

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

2505: l_po_info c_po_info%ROWTYPE;
2506:
2507:
2508: /* Bug 2137423: checking MTL_INTERORG_PARAMETERS to internal transaction type */
2509: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER , c_to_organization_id NUMBER) IS
2510: SELECT intransit_type
2511: FROM mtl_interorg_parameters
2512: WHERE from_organization_id = c_from_organization_id AND
2513: to_organization_id = c_to_organization_id;

Line 2511: FROM mtl_interorg_parameters

2507:
2508: /* Bug 2137423: checking MTL_INTERORG_PARAMETERS to internal transaction type */
2509: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER , c_to_organization_id NUMBER) IS
2510: SELECT intransit_type
2511: FROM mtl_interorg_parameters
2512: WHERE from_organization_id = c_from_organization_id AND
2513: to_organization_id = c_to_organization_id;
2514: l_intransit_type NUMBER;
2515:

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

3194: l_trx_source_type_id := 8;
3195: l_trx_action_id := 2;
3196: l_trx_type_code := 50 /* Subinv_xfer */;
3197: ELSIF (l_po_info.destination_organization_id <> l_po_info.source_organization_id) THEN
3198: /* Bug 2137423, check mtl_interorg_parameters to decide transaction codes */
3199: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
3200: l_po_info.destination_organization_id);
3201: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
3202: IF c_mtl_interorg_parameters%NOTFOUND THEN

Line 3199: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,

3195: l_trx_action_id := 2;
3196: l_trx_type_code := 50 /* Subinv_xfer */;
3197: ELSIF (l_po_info.destination_organization_id <> l_po_info.source_organization_id) THEN
3198: /* Bug 2137423, check mtl_interorg_parameters to decide transaction codes */
3199: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
3200: l_po_info.destination_organization_id);
3201: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
3202: IF c_mtl_interorg_parameters%NOTFOUND THEN
3203: /* default to intransit */

Line 3201: FETCH c_mtl_interorg_parameters INTO l_intransit_type;

3197: ELSIF (l_po_info.destination_organization_id <> l_po_info.source_organization_id) THEN
3198: /* Bug 2137423, check mtl_interorg_parameters to decide transaction codes */
3199: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
3200: l_po_info.destination_organization_id);
3201: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
3202: IF c_mtl_interorg_parameters%NOTFOUND THEN
3203: /* default to intransit */
3204: l_trx_source_type_id := 8;
3205: l_trx_action_id := 21;

Line 3202: IF c_mtl_interorg_parameters%NOTFOUND THEN

3198: /* Bug 2137423, check mtl_interorg_parameters to decide transaction codes */
3199: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
3200: l_po_info.destination_organization_id);
3201: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
3202: IF c_mtl_interorg_parameters%NOTFOUND THEN
3203: /* default to intransit */
3204: l_trx_source_type_id := 8;
3205: l_trx_action_id := 21;
3206: l_trx_type_code := 62; /* intransit_shpmnt */

Line 3218: CLOSE c_mtl_interorg_parameters;

3214: l_trx_action_id := 21;
3215: l_trx_type_code := 62; /* intransit_shpmnt */
3216: END IF;
3217: END IF;
3218: CLOSE c_mtl_interorg_parameters;
3219: IF l_debug_on THEN
3220: WSH_DEBUG_SV.log(l_module_name,'l_intransit_type', l_intransit_type);
3221: WSH_DEBUG_SV.log(l_module_name,'l_trx_source_type_id', l_trx_source_type_id);
3222: WSH_DEBUG_SV.log(l_module_name,'l_trx_action_id', l_trx_action_id);