APPS.INV_PROJECT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1100: FROM mtl_item_locations mil, wms_license_plate_numbers wlpn

1096: x_return_status := FND_API.G_RET_STS_SUCCESS;
1097:
1098: SELECT mil.segment19, mil.segment20
1099: INTO l_project_id, l_task_id
1100: FROM mtl_item_locations mil, wms_license_plate_numbers wlpn
1101: WHERE wlpn.lpn_id = p_lpn_id
1102: AND wlpn.organization_id = p_organization_id
1103: AND wlpn.organization_id = mil.organization_id
1104: AND wlpn.locator_id = mil.inventory_location_id;

Line 1600: * FROM WMS_LICENSE_PLATE_NUMBERS

1596: * INV_PROJECT.GET_PROJECT_NUMBER,
1597: * INV_PROJECT.GET_TASK_ID,
1598: * INV_PROJECT.GET_TASK_NUMBER,
1599: * ..
1600: * FROM WMS_LICENSE_PLATE_NUMBERS
1601: *
1602: */
1603: FUNCTION GET_PROJECT_NUMBER RETURN VARCHAR2 IS
1604: BEGIN