DBA Data[Home] [Help]

APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on MTL_INTERORG_SHIP_METHODS

Line 806: l_in_transit MTL_INTERORG_SHIP_METHODS.INTRANSIT_TIME%TYPE;

802: )
803: IS
804:
805: l_api_name VARCHAR2(30) := 'validate_receive_date';
806: l_in_transit MTL_INTERORG_SHIP_METHODS.INTRANSIT_TIME%TYPE;
807: l_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
808: l_receive_date DATE;
809:
810: l_date_flag NUMBER;

Line 1326: l_intransit MTL_INTERORG_SHIP_METHODS.INTRANSIT_TIME%TYPE;

1322: , x_in_transit OUT NOCOPY NUMBER
1323: )
1324: IS
1325: l_api_name VARCHAR2(30):= 'get_in_transit';
1326: l_intransit MTL_INTERORG_SHIP_METHODS.INTRANSIT_TIME%TYPE;
1327: l_default_flag NUMBER;
1328: l_ship_method MTL_INTERORG_SHIP_METHODS.ship_method%TYPE;
1329:
1330: CURSOR ship_method_c IS

Line 1328: l_ship_method MTL_INTERORG_SHIP_METHODS.ship_method%TYPE;

1324: IS
1325: l_api_name VARCHAR2(30):= 'get_in_transit';
1326: l_intransit MTL_INTERORG_SHIP_METHODS.INTRANSIT_TIME%TYPE;
1327: l_default_flag NUMBER;
1328: l_ship_method MTL_INTERORG_SHIP_METHODS.ship_method%TYPE;
1329:
1330: CURSOR ship_method_c IS
1331: SELECT
1332: ship_methods.Intransit_Time

Line 1336: MTL_INTERORG_SHIP_METHODS ship_methods

1332: ship_methods.Intransit_Time
1333: , ship_methods.default_flag
1334: , ship_methods.ship_method
1335: FROM
1336: MTL_INTERORG_SHIP_METHODS ship_methods
1337: WHERE
1338: ship_methods.from_organization_id = p_ship_from_org_id
1339: AND ship_methods.To_Organization_Id = p_ship_to_org_id
1340: AND ship_methods.default_flag = 1;