APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on MTL_SHIPPING_NETWORK_VIEW

Line 814: l_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;

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;
818: l_tp_org_id NUMBER;

Line 876: FROM MTL_SHIPPING_NETWORK_VIEW ship_net

872: BEGIN
873:
874: SELECT ship_net.INTRANSIT_TYPE -- 1 is direct and 2 is instrant
875: INTO l_intransit_type
876: FROM MTL_SHIPPING_NETWORK_VIEW ship_net
877: WHERE ship_net.FROM_ORGANIZATION_ID = p_line_ship_from_org_id
878: AND ship_net.TO_ORGANIZATION_ID = l_tp_org_id;
879: EXCEPTION
880: WHEN no_data_found THEN