APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on MTL_INTERORG_SHIP_METHODS

Line 813: l_in_transit MTL_INTERORG_SHIP_METHODS.INTRANSIT_TIME%TYPE;

809: )
810: IS
811:
812: l_api_name VARCHAR2(30) := 'validate_receive_date';
813: l_in_transit MTL_INTERORG_SHIP_METHODS.INTRANSIT_TIME%TYPE;
814: l_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
815: l_receive_date DATE;
816:
817: l_date_flag NUMBER;

Line 1346: l_intransit MTL_INTERORG_SHIP_METHODS.INTRANSIT_TIME%TYPE;

1342: , x_in_transit OUT NOCOPY NUMBER
1343: )
1344: IS
1345: l_api_name VARCHAR2(30):= 'get_in_transit';
1346: l_intransit MTL_INTERORG_SHIP_METHODS.INTRANSIT_TIME%TYPE;
1347: l_default_flag NUMBER;
1348: l_ship_method MTL_INTERORG_SHIP_METHODS.ship_method%TYPE;
1349:
1350: CURSOR ship_method_c IS

Line 1348: l_ship_method MTL_INTERORG_SHIP_METHODS.ship_method%TYPE;

1344: IS
1345: l_api_name VARCHAR2(30):= 'get_in_transit';
1346: l_intransit MTL_INTERORG_SHIP_METHODS.INTRANSIT_TIME%TYPE;
1347: l_default_flag NUMBER;
1348: l_ship_method MTL_INTERORG_SHIP_METHODS.ship_method%TYPE;
1349:
1350: CURSOR ship_method_c IS
1351: SELECT
1352: ship_methods.Intransit_Time

Line 1356: MTL_INTERORG_SHIP_METHODS ship_methods

1352: ship_methods.Intransit_Time
1353: , ship_methods.default_flag
1354: , ship_methods.ship_method
1355: FROM
1356: MTL_INTERORG_SHIP_METHODS ship_methods
1357: WHERE
1358: ship_methods.from_organization_id = p_ship_from_org_id
1359: AND ship_methods.To_Organization_Id = p_ship_to_org_id
1360: AND ship_methods.default_flag = 1;