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_DELIVERY_DETAILS_INV dependencies on MTL_INTERORG_PARAMETERS

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

5577: --RTV changes
5578:
5579: l_po_info c_po_info%ROWTYPE;
5580:
5581: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER , c_to_organization_id NUMBER) IS
5582: SELECT intransit_type
5583: FROM mtl_interorg_parameters
5584: WHERE from_organization_id = c_from_organization_id AND
5585: to_organization_id = c_to_organization_id;

Line 5583: FROM mtl_interorg_parameters

5579: l_po_info c_po_info%ROWTYPE;
5580:
5581: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER , c_to_organization_id NUMBER) IS
5582: SELECT intransit_type
5583: FROM mtl_interorg_parameters
5584: WHERE from_organization_id = c_from_organization_id AND
5585: to_organization_id = c_to_organization_id;
5586: l_intransit_type NUMBER;
5587:

Line 5644: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,

5640: (l_po_info.source_organization_id = l_po_info.destination_organization_id) THEN
5641: x_transaction_type_id := 50 /* Subinv_xfer */;
5642: ELSIF (l_po_info.destination_organization_id <> l_po_info.source_organization_id) THEN
5643:
5644: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
5645: l_po_info.destination_organization_id);
5646: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
5647:
5648: IF c_mtl_interorg_parameters%NOTFOUND THEN

Line 5646: FETCH c_mtl_interorg_parameters INTO l_intransit_type;

5642: ELSIF (l_po_info.destination_organization_id <> l_po_info.source_organization_id) THEN
5643:
5644: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
5645: l_po_info.destination_organization_id);
5646: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
5647:
5648: IF c_mtl_interorg_parameters%NOTFOUND THEN
5649: /* default to intransit */
5650: x_transaction_type_id := 62; /* intransit_shpmnt */

Line 5648: IF c_mtl_interorg_parameters%NOTFOUND THEN

5644: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
5645: l_po_info.destination_organization_id);
5646: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
5647:
5648: IF c_mtl_interorg_parameters%NOTFOUND THEN
5649: /* default to intransit */
5650: x_transaction_type_id := 62; /* intransit_shpmnt */
5651: ELSE
5652: IF l_intransit_type = 1 THEN

Line 5658: CLOSE c_mtl_interorg_parameters;

5654: ELSE
5655: x_transaction_type_id := 62; /* intransit_shpmnt */
5656: END IF;
5657: END IF;
5658: CLOSE c_mtl_interorg_parameters;
5659: END IF;
5660: ELSE
5661: x_transaction_type_id := 33;
5662: END IF;

Line 5707: IF c_mtl_interorg_parameters%isopen THEN

5703: END IF;
5704: IF c_po_info%isopen THEN
5705: CLOSE c_po_info;
5706: END IF;
5707: IF c_mtl_interorg_parameters%isopen THEN
5708: CLOSE c_mtl_interorg_parameters;
5709: END IF;
5710: --RTV changes
5711: IF c_get_rtv_type%isopen THEN

Line 5708: CLOSE c_mtl_interorg_parameters;

5704: IF c_po_info%isopen THEN
5705: CLOSE c_po_info;
5706: END IF;
5707: IF c_mtl_interorg_parameters%isopen THEN
5708: CLOSE c_mtl_interorg_parameters;
5709: END IF;
5710: --RTV changes
5711: IF c_get_rtv_type%isopen THEN
5712: CLOSE c_get_rtv_type;