APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on MTL_SHIPPING_NETWORK_VIEW

Line 807: l_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;

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

Line 856: FROM MTL_SHIPPING_NETWORK_VIEW ship_net

852: BEGIN
853:
854: SELECT ship_net.INTRANSIT_TYPE -- 1 is direct and 2 is instrant
855: INTO l_intransit_type
856: FROM MTL_SHIPPING_NETWORK_VIEW ship_net
857: WHERE ship_net.FROM_ORGANIZATION_ID = p_line_ship_from_org_id
858: AND ship_net.TO_ORGANIZATION_ID = l_tp_org_id;
859: EXCEPTION
860: WHEN no_data_found THEN