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 2997: /* Bug 2137423: checking MTL_INTERORG_PARAMETERS to internal transaction type */

2993: AND pl.requisition_line_id = pd.requisition_line_id;
2994: l_po_info c_po_info%ROWTYPE;
2995:
2996:
2997: /* Bug 2137423: checking MTL_INTERORG_PARAMETERS to internal transaction type */
2998: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER , c_to_organization_id NUMBER) IS
2999: SELECT intransit_type
3000: FROM mtl_interorg_parameters
3001: WHERE from_organization_id = c_from_organization_id AND

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

2994: l_po_info c_po_info%ROWTYPE;
2995:
2996:
2997: /* Bug 2137423: checking MTL_INTERORG_PARAMETERS to internal transaction type */
2998: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER , c_to_organization_id NUMBER) IS
2999: SELECT intransit_type
3000: FROM mtl_interorg_parameters
3001: WHERE from_organization_id = c_from_organization_id AND
3002: to_organization_id = c_to_organization_id;

Line 3000: FROM mtl_interorg_parameters

2996:
2997: /* Bug 2137423: checking MTL_INTERORG_PARAMETERS to internal transaction type */
2998: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER , c_to_organization_id NUMBER) IS
2999: SELECT intransit_type
3000: FROM mtl_interorg_parameters
3001: WHERE from_organization_id = c_from_organization_id AND
3002: to_organization_id = c_to_organization_id;
3003: l_intransit_type NUMBER;
3004:

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

3813: l_trx_source_type_id := 8;
3814: l_trx_action_id := 2;
3815: l_trx_type_code := 50 /* Subinv_xfer */;
3816: ELSIF (l_po_info.destination_organization_id <> l_po_info.source_organization_id) THEN
3817: /* Bug 2137423, check mtl_interorg_parameters to decide transaction codes */
3818: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
3819: l_po_info.destination_organization_id);
3820: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
3821: IF c_mtl_interorg_parameters%NOTFOUND THEN

Line 3818: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,

3814: l_trx_action_id := 2;
3815: l_trx_type_code := 50 /* Subinv_xfer */;
3816: ELSIF (l_po_info.destination_organization_id <> l_po_info.source_organization_id) THEN
3817: /* Bug 2137423, check mtl_interorg_parameters to decide transaction codes */
3818: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
3819: l_po_info.destination_organization_id);
3820: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
3821: IF c_mtl_interorg_parameters%NOTFOUND THEN
3822: /* default to intransit */

Line 3820: FETCH c_mtl_interorg_parameters INTO l_intransit_type;

3816: ELSIF (l_po_info.destination_organization_id <> l_po_info.source_organization_id) THEN
3817: /* Bug 2137423, check mtl_interorg_parameters to decide transaction codes */
3818: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
3819: l_po_info.destination_organization_id);
3820: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
3821: IF c_mtl_interorg_parameters%NOTFOUND THEN
3822: /* default to intransit */
3823: l_trx_source_type_id := 8;
3824: l_trx_action_id := 21;

Line 3821: IF c_mtl_interorg_parameters%NOTFOUND THEN

3817: /* Bug 2137423, check mtl_interorg_parameters to decide transaction codes */
3818: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
3819: l_po_info.destination_organization_id);
3820: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
3821: IF c_mtl_interorg_parameters%NOTFOUND THEN
3822: /* default to intransit */
3823: l_trx_source_type_id := 8;
3824: l_trx_action_id := 21;
3825: l_trx_type_code := 62; /* intransit_shpmnt */

Line 3837: CLOSE c_mtl_interorg_parameters;

3833: l_trx_action_id := 21;
3834: l_trx_type_code := 62; /* intransit_shpmnt */
3835: END IF;
3836: END IF;
3837: CLOSE c_mtl_interorg_parameters;
3838: IF l_debug_on THEN
3839: WSH_DEBUG_SV.log(l_module_name,'l_intransit_type', l_intransit_type);
3840: WSH_DEBUG_SV.log(l_module_name,'l_trx_source_type_id', l_trx_source_type_id);
3841: WSH_DEBUG_SV.log(l_module_name,'l_trx_action_id', l_trx_action_id);