APPS.RCV_INTRANSIT_SV dependencies on MTL_INTERORG_SHIP_METHODS

Line 24: ** Get the mtl_interorg_ship_methods row for the from and to org id

20:
21: BEGIN
22:
23: /*
24: ** Get the mtl_interorg_ship_methods row for the from and to org id
25: ** combination. This will provide you with the intransit lead time
26: */
27:
28: BEGIN

Line 44: FROM MTL_INTERORG_SHIP_METHODS MSM

40: */
41:
42: SELECT MSM.INTRANSIT_TIME
43: INTO X_INTRANSIT_TIME
44: FROM MTL_INTERORG_SHIP_METHODS MSM
45: WHERE MSM.FROM_ORGANIZATION_ID = X_from_organization_id
46: AND MSM.TO_ORGANIZATION_ID = X_to_organization_id
47: AND MSM.DEFAULT_FLAG=1;
48:

Line 69: ** If more than one row exists for the MTL_INTERORG_SHIP_METHODS then

65:
66: EXCEPTION
67:
68: /*Bug# 1881765
69: ** If more than one row exists for the MTL_INTERORG_SHIP_METHODS then
70: take the first shipment Method from the set of defined methods
71: Else If no row exists for the MTL_INTERORG_SHIP_METHODS then just
72: set the expected shipped date to the need by date.
73: */

Line 71: Else If no row exists for the MTL_INTERORG_SHIP_METHODS then just

67:
68: /*Bug# 1881765
69: ** If more than one row exists for the MTL_INTERORG_SHIP_METHODS then
70: take the first shipment Method from the set of defined methods
71: Else If no row exists for the MTL_INTERORG_SHIP_METHODS then just
72: set the expected shipped date to the need by date.
73: */
74:
75: WHEN NO_DATA_FOUND THEN

Line 81: FROM MTL_INTERORG_SHIP_METHODS MSM

77: BEGIN
78:
79: SELECT MSM.INTRANSIT_TIME
80: INTO X_INTRANSIT_TIME
81: FROM MTL_INTERORG_SHIP_METHODS MSM
82: WHERE MSM.FROM_ORGANIZATION_ID = X_from_organization_id
83: AND MSM.TO_ORGANIZATION_ID = X_to_organization_id
84: AND ROWNUM=1;
85: